View: AR_RCT_METHOD_S_V

Product:	AR - Receivables
Description:	cash receipt receipt method shared extract
Implementation/DBA Data:	APPS.AR_RCT_METHOD_S_V

View Text

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

Columns