AR_RCT_METHOD_H

Details

Schema: FUSION
Object owner: AR
Object type: VIEW

Columns

Name
RCT_CLASS_CLEAR_FLAG RCT_CLASS_CONFIRM_FLAG RCT_CLASS_CREATE_METHOD_CD RCT_CLASS_CREATION_STATUS RCT_CLASS_NAME RCT_CLASS_NOTES_RECEIVABLE RCT_CLASS_RECEIPT_CLASS_ID RCT_CLASS_REMIT_FLAG RCT_CLASS_REMIT_METHOD_CD RCT_MTHD_NAME RCT_MTHD_PAYMENT_TYPE_CODE RCT_MTHD_PRINTED_NAME RCT_MTHD_RECEIPT_CLASS_ID RCT_MTHD_RECEIPT_METHOD_ID RCT_CLASS_GLOBAL_ATTR1 RCT_CLASS_GLOBAL_ATTR2 RCT_CLASS_GLOBAL_ATTR3 RCT_CLASS_GLOBAL_ATTR_CAT EVENT_ID LEDGER_ID RCT_MTHD_GLOBAL_ATTR_CTG RCT_MTHD_GLOBAL_ATTR1 RCT_MTHD_GLOBAL_ATTR2 RCT_MTHD_GLOBAL_ATTR3 RCT_MTHD_GLOBAL_ATTR4 RCT_MTHD_GLOBAL_ATTR5 RCT_MTHD_GLOBAL_ATTR6 RCT_MTHD_GLOBAL_ATTR7 RCT_MTHD_GLOBAL_ATTR8 RCT_MTHD_GLOBAL_ATTR9 RCT_MTHD_GLOBAL_ATTR10 RCT_MTHD_GLOBAL_ATTR11 RCT_MTHD_GLOBAL_ATTR12 RCT_MTHD_GLOBAL_ATTR13 RCT_MTHD_GLOBAL_ATTR14 RCT_MTHD_GLOBAL_ATTR15 RCT_MTHD_GLOBAL_ATTR16 RCT_MTHD_GLOBAL_ATTR17 RCT_MTHD_GLOBAL_ATTR18 RCT_MTHD_GLOBAL_ATTR19 RCT_MTHD_GLOBAL_ATTR20

Name

RCT_CLASS_CLEAR_FLAG

RCT_CLASS_CONFIRM_FLAG

RCT_CLASS_CREATE_METHOD_CD

RCT_CLASS_CREATION_STATUS

RCT_CLASS_NAME

RCT_CLASS_NOTES_RECEIVABLE

RCT_CLASS_RECEIPT_CLASS_ID

RCT_CLASS_REMIT_FLAG

RCT_CLASS_REMIT_METHOD_CD

RCT_MTHD_NAME

RCT_MTHD_PAYMENT_TYPE_CODE

RCT_MTHD_PRINTED_NAME

RCT_MTHD_RECEIPT_CLASS_ID

RCT_MTHD_RECEIPT_METHOD_ID

RCT_CLASS_GLOBAL_ATTR1

RCT_CLASS_GLOBAL_ATTR2

RCT_CLASS_GLOBAL_ATTR3

RCT_CLASS_GLOBAL_ATTR_CAT

EVENT_ID

LEDGER_ID

RCT_MTHD_GLOBAL_ATTR_CTG

RCT_MTHD_GLOBAL_ATTR1

RCT_MTHD_GLOBAL_ATTR2

RCT_MTHD_GLOBAL_ATTR3

RCT_MTHD_GLOBAL_ATTR4

RCT_MTHD_GLOBAL_ATTR5

RCT_MTHD_GLOBAL_ATTR6

RCT_MTHD_GLOBAL_ATTR7

RCT_MTHD_GLOBAL_ATTR8

RCT_MTHD_GLOBAL_ATTR9

RCT_MTHD_GLOBAL_ATTR10

RCT_MTHD_GLOBAL_ATTR11

RCT_MTHD_GLOBAL_ATTR12

RCT_MTHD_GLOBAL_ATTR13

RCT_MTHD_GLOBAL_ATTR14

RCT_MTHD_GLOBAL_ATTR15

RCT_MTHD_GLOBAL_ATTR16

RCT_MTHD_GLOBAL_ATTR17

RCT_MTHD_GLOBAL_ATTR18

RCT_MTHD_GLOBAL_ATTR19

RCT_MTHD_GLOBAL_ATTR20

Query

SQL_Statement
SELECT /+INDEX(l ar_xla_lines_extract_n1)/ rc1.clear_flag rct_class_clear_flag ,rc1.confirm_flag rct_class_confirm_flag ,rc1.creation_method_code rct_class_create_method_cd ,rc1.creation_status rct_class_creation_status ,rc1.name rct_class_name ,rc1.notes_receivable rct_class_notes_receivable ,rc1.receipt_class_id rct_class_receipt_class_id ,rc1.remit_flag rct_class_remit_flag ,rc1.remit_method_code rct_class_remit_method_cd ,rm1.name rct_mthd_name ,rm1.payment_channel_code rct_mthd_payment_type_code ,rm1.printed_name rct_mthd_printed_name ,rm1.receipt_class_id rct_mthd_receipt_class_id ,rm1.receipt_method_id rct_mthd_receipt_method_id ,rc1.global_attribute1 RCT_CLASS_GLOBAL_ATTR1 ,rc1.global_attribute2 RCT_CLASS_GLOBAL_ATTR2 ,rc1.global_attribute3 RCT_CLASS_GLOBAL_ATTR3,rc1.global_attribute_category RCT_CLASS_GLOBAL_ATTR_CAT,l.event_id event_id ,l.ledger_id ledger_id,rm1.global_attribute_category rct_mthd_global_attr_ctg,rm1.global_attribute1 rct_mthd_global_attr1,rm1.global_attribute2 rct_mthd_global_attr2,rm1.global_attribute3 rct_mthd_global_attr3,rm1.global_attribute4 rct_mthd_global_attr4,rm1.global_attribute5 rct_mthd_global_attr5,rm1.global_attribute6 rct_mthd_global_attr6,rm1.global_attribute7 rct_mthd_global_attr7,rm1.global_attribute8 rct_mthd_global_attr8,rm1.global_attribute9 rct_mthd_global_attr9, rm1.global_attribute10 rct_mthd_global_attr10,rm1.global_attribute11 rct_mthd_global_attr11,rm1.global_attribute12 rct_mthd_global_attr12,rm1.global_attribute13 rct_mthd_global_attr13,rm1.global_attribute14 rct_mthd_global_attr14,rm1.global_attribute15 rct_mthd_global_attr15,rm1.global_attribute16 rct_mthd_global_attr16,rm1.global_attribute17 rct_mthd_global_attr17,rm1.global_attribute18 rct_mthd_global_attr18,rm1.global_attribute19 rct_mthd_global_attr19,rm1.global_attribute20 rct_mthd_global_attr20 FROM ar_receipt_methods rm1 ,ar_receipt_classes rc1 ,ar_xla_lines_extract l WHERE rm1.receipt_method_id = l.receipt_method_id AND l.level_flag = 'H' and rm1.receipt_class_id = rc1.receipt_class_id

SQL_Statement

SELECT /*+INDEX(l ar_xla_lines_extract_n1)*/ rc1.clear_flag rct_class_clear_flag ,rc1.confirm_flag rct_class_confirm_flag ,rc1.creation_method_code rct_class_create_method_cd ,rc1.creation_status rct_class_creation_status ,rc1.name rct_class_name ,rc1.notes_receivable rct_class_notes_receivable ,rc1.receipt_class_id rct_class_receipt_class_id ,rc1.remit_flag rct_class_remit_flag ,rc1.remit_method_code rct_class_remit_method_cd ,rm1.name rct_mthd_name ,rm1.payment_channel_code rct_mthd_payment_type_code ,rm1.printed_name rct_mthd_printed_name ,rm1.receipt_class_id rct_mthd_receipt_class_id ,rm1.receipt_method_id rct_mthd_receipt_method_id ,rc1.global_attribute1 RCT_CLASS_GLOBAL_ATTR1 ,rc1.global_attribute2 RCT_CLASS_GLOBAL_ATTR2 ,rc1.global_attribute3 RCT_CLASS_GLOBAL_ATTR3,rc1.global_attribute_category RCT_CLASS_GLOBAL_ATTR_CAT,l.event_id event_id ,l.ledger_id ledger_id,rm1.global_attribute_category rct_mthd_global_attr_ctg,rm1.global_attribute1 rct_mthd_global_attr1,rm1.global_attribute2 rct_mthd_global_attr2,rm1.global_attribute3 rct_mthd_global_attr3,rm1.global_attribute4 rct_mthd_global_attr4,rm1.global_attribute5 rct_mthd_global_attr5,rm1.global_attribute6 rct_mthd_global_attr6,rm1.global_attribute7 rct_mthd_global_attr7,rm1.global_attribute8 rct_mthd_global_attr8,rm1.global_attribute9 rct_mthd_global_attr9,

rm1.global_attribute10 rct_mthd_global_attr10,rm1.global_attribute11 rct_mthd_global_attr11,rm1.global_attribute12 rct_mthd_global_attr12,rm1.global_attribute13 rct_mthd_global_attr13,rm1.global_attribute14 rct_mthd_global_attr14,rm1.global_attribute15 rct_mthd_global_attr15,rm1.global_attribute16 rct_mthd_global_attr16,rm1.global_attribute17 rct_mthd_global_attr17,rm1.global_attribute18 rct_mthd_global_attr18,rm1.global_attribute19 rct_mthd_global_attr19,rm1.global_attribute20 rct_mthd_global_attr20 FROM ar_receipt_methods rm1 ,ar_receipt_classes rc1 ,ar_xla_lines_extract l WHERE rm1.receipt_method_id = l.receipt_method_id AND l.level_flag = 'H' and rm1.receipt_class_id = rc1.receipt_class_id