AR_RCT_METHOD_H_V

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

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 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