VIEW: APPS.AR_BR_ASSIGNMENTS_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)