AR_RCT_METHOD_S_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 LINE_NUMBER LANGUAGE LEDGER_ID |
Query
SQL_Statement |
---|
SELECT 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.line_number line_number , l.language language , 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 l.event_class_code = 'CREDIT_MEMO' AND rm1.receipt_class_id = rc1.receipt_class_id |