VIEW: APPS.AR_RCT_METHOD_H_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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