View: AR_BR_ASSIGNMENTS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.AR_BR_ASSIGNMENTS_V

View Text

SELECT LINES.ROWID
, LINES.CUSTOMER_TRX_LINE_ID
, LINES.CUSTOMER_TRX_ID
, LINES.BR_REF_CUSTOMER_TRX_ID
, LINES.BR_REF_PAYMENT_SCHEDULE_ID
, LINES.EXTENDED_AMOUNT
, LINES.EXTENDED_ACCTD_AMOUNT
, /* CUSTOMER TRX */ TRX.TRX_NUMBER
, TRX.DOC_SEQUENCE_VALUE
, TRX.TRX_DATE
, TRX.COMMENTS
, TRX.PURCHASE_ORDER
, /* PAYMENT SCHEDULE */ PAYS.INVOICE_CURRENCY_CODE
, PAYS.AMOUNT_DUE_ORIGINAL
, PAYS.AMOUNT_DUE_ORIGINAL*NVL(PAYS.EXCHANGE_RATE
, 1)
, PAYS.AMOUNT_DUE_REMAINING
, PAYS.ACCTD_AMOUNT_DUE_REMAINING
, PAYS.DUE_DATE
, PAYS.EXCHANGE_RATE
, PAYS.TERMS_SEQUENCE_NUMBER
, /* CUSTOMER */ PARTY.JGZZ_FISCAL_CODE
, CUST_ACCT.ACCOUNT_NUMBER
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50)
, CUST_ACCT.CUSTOMER_CLASS_CODE
, PARTY.CATEGORY_CODE
, AR_LOOKUPS_CUST_CAT.MEANING
, /* TRANSACTION TYPE */ TYPES.NAME
, AR_LOOKUPS_INVCM.MEANING
, TYPES.TYPE
, /* RECEIPT METHOD */ METH.NAME
, METH.RECEIPT_METHOD_ID
, /* SITE */ SITE.LOCATION
, TRX.BILL_TO_SITE_USE_ID
, /* BANK DETAILS */ NULL BANK_NAME
, NULL BANK_BRANCH_ID
, NULL BANK_ACCOUNT_ID
, /* CONSOLODATED BILLING */ CON.CONS_BILLING_NUMBER
, PAYS.CONS_INV_ID
, /* DFF */ LINES.ATTRIBUTE_CATEGORY
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
FROM AR_LOOKUPS AR_LOOKUPS_INVCM
, AR_LOOKUPS AR_LOOKUPS_CUST_CAT
, AR_CONS_INV_ALL CON
, RA_CUSTOMER_TRX TRX
, AR_PAYMENT_SCHEDULES PAYS
, RA_CUSTOMER_TRX_LINES LINES
, HZ_CUST_ACCOUNTS CUST_ACCT
, HZ_PARTIES PARTY
, RA_CUST_TRX_TYPES TYPES
, AR_RECEIPT_METHODS METH
, HZ_CUST_SITE_USES SITE
, IBY_TRXN_EXTENSIONS_V IBY
WHERE AR_LOOKUPS_CUST_CAT.LOOKUP_TYPE(+) = 'CUSTOMER_CATEGORY'
AND AR_LOOKUPS_INVCM.LOOKUP_TYPE = 'INV/CM'
AND AR_LOOKUPS_CUST_CAT.LOOKUP_CODE (+) = PARTY.CATEGORY_CODE
AND AR_LOOKUPS_INVCM.LOOKUP_CODE = TYPES.TYPE
AND TRX.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID
AND NVL( TRX.BILL_TO_CUSTOMER_ID
, TRX.DRAWEE_ID ) = CUST_ACCT.CUST_ACCOUNT_ID
AND CUST_ACCT.PARTY_ID = PARTY.PARTY_ID
AND CON.CONS_INV_ID(+) = PAYS.CONS_INV_ID
AND TRX.CUSTOMER_TRX_ID = PAYS.CUSTOMER_TRX_ID
AND TRX.CUST_TRX_TYPE_ID = TYPES.CUST_TRX_TYPE_ID
AND SITE.SITE_USE_ID = NVL(TRX.BILL_TO_SITE_USE_ID
, TRX.DRAWEE_SITE_USE_ID )
AND PAYS.PAYMENT_SCHEDULE_ID = LINES.BR_REF_PAYMENT_SCHEDULE_ID
AND IBY.TRXN_EXTENSION_ID(+) = TRX.PAYMENT_TRXN_EXTENSION_ID
AND TRX.RECEIPT_METHOD_ID = METH.RECEIPT_METHOD_ID (+)

Columns