FND Design Data [Home] [Help]

View: ARFV_CREDITS_OLD1

Product: AR - Receivables
Description: - Retrofitted
Implementation/DBA Data: Not implemented in this database
View Text

SELECT /* UNIQUE ATTRIBUTES */ CT.CUSTOMER_TRX_ID
, /* REGULAR ATTRIBUTES */ CT.TRX_NUMBER
, CT.DOC_SEQUENCE_VALUE
, CT.TRX_DATE
, CT.EXCHANGE_RATE
, CT.EXCHANGE_RATE_TYPE
, CT.EXCHANGE_DATE
, '_LA:CT.COMPLETE_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, '_LA:CT.STATUS_TRX:AR_LOOKUPS:INVOICE_TRX_STATUS:MEANING'
, CT.PURCHASE_ORDER
, CT.PURCHASE_ORDER_DATE
, CT.PURCHASE_ORDER_REVISION
, CT.REASON_CODE
, CT.CUSTOMER_REFERENCE
, '_LA:CT.FINANCE_CHARGES:AR_LOOKUPS:YES/NO:MEANING'
, CT.TERM_DUE_DATE
, '_LA:CT.DEFAULT_TAX_EXEMPT_FLAG:AR_LOOKUPS:TAX_CONTROL_FLAG:MEANING'
, CT.SHIP_VIA
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, '_LA:CT.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, '_LA:CT.EDI_PROCESSED_FLAG:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_ORIGINAL_DATE
, CT.PRINTING_LAST_PRINTED
, '_LA:CT.PRINTING_PENDING:AR_LOOKUPS:YES/NO:MEANING'
, CT.PRINTING_COUNT
, CT.ORIG_SYSTEM_BATCH_NAME
, /* RESOLVED FK RESOLUTIONS */ BAT.NAME
, DECODE(CT.BILL_TO_CONTACT_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_CONTACT_NAME(CT.BILL_TO_CONTACT_ID)
, 1
, 91)) BILL_TO_CONTACT_NAME
, DECODE(CT.SHIP_TO_CONTACT_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_CONTACT_NAME(CT.SHIP_TO_CONTACT_ID)
, 1
, 91)) SHIP_TO_CONTACT_NAME
, DECODE(CT.SOLD_TO_CONTACT_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_CONTACT_NAME(CT.SOLD_TO_CONTACT_ID)
, 1
, 91)) SOLD_TO_CONTACT_NAME
, SUBSTRB(BIPARTY.PARTY_NAME
, 1
, 50) BILL_TO_CUSTOMER
, DECODE(CT.SHIP_TO_CUSTOMER_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_NAME(CT.SHIP_TO_CUSTOMER_ID)
, 1
, 50)) SHIP_TO_CUSTOMER
, DECODE(CT.SOLD_TO_CUSTOMER_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_NAME(CT.SOLD_TO_CUSTOMER_ID)
, 1
, 50)) SOLD_TO_CUSTOMER
, DECODE(CT.PAYING_CUSTOMER_ID
, NULL
, NULL
, SUBSTR(HZ_COMMON_PUB.GET_CUST_NAME(CT.PAYING_CUSTOMER_ID)
, 1
, 50)) PAYING_CUSTOMER
, CTT.NAME
, SAL.NAME
, BISU.LOCATION
, SISU.LOCATION
, SOSU.LOCATION
, PASU.LOCATION
, SUBSTR(HZ_COMMON_PUB.GET_CUST_ADDRESS(CT.REMIT_TO_ADDRESS_ID)
, 1
, 240) REMIT_TO_ADDRESS
, BACC.BANK_ACCOUNT_NAME
, BACC.BANK_ACCOUNT_NUM
, RM.NAME
, TER.NAME
, AOU.NAME
, '_DF:AR:RA_CUSTOMER_TRX:CT'
, '_DF:AR:RA_INTERFACE_HEADER:CT'
, '_DF:JG:JG_RA_CUSTOMER_TRX:CT'
, /* IDS */ CT.BATCH_ID
, CT.TERM_ID
, CT.BILL_TO_CONTACT_ID
, CT.SHIP_TO_CONTACT_ID
, CT.SOLD_TO_CONTACT_ID
, CT.BILL_TO_CUSTOMER_ID
, CT.SHIP_TO_CUSTOMER_ID
, CT.SOLD_TO_CUSTOMER_ID
, CT.PAYING_CUSTOMER_ID
, CT.CUST_TRX_TYPE_ID
, CT.PRIMARY_SALESREP_ID
, CT.BILL_TO_SITE_USE_ID
, CT.SHIP_TO_SITE_USE_ID
, CT.SOLD_TO_SITE_USE_ID
, CT.PAYING_SITE_USE_ID
, CT.REMIT_TO_ADDRESS_ID
, CT.CUSTOMER_BANK_ACCOUNT_ID
, CT.RECEIPT_METHOD_ID
, CT.ORG_ID
, /* WHO COLUMNS */ CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
, CT.INTERNAL_NOTES
, CT.COMMENTS
FROM RA_CUSTOMER_TRX_ALL CT
, RA_BATCHES_ALL BAT
, HZ_PARTIES BIPARTY
, HZ_CUST_ACCOUNTS BICUST_ACCT
, RA_CUST_TRX_TYPES_ALL CTT
, RA_SALESREPS_ALL SAL
, HZ_CUST_SITE_USES_ALL BISU
, HZ_CUST_SITE_USES_ALL SISU
, HZ_CUST_SITE_USES_ALL SOSU
, HZ_CUST_SITE_USES_ALL PASU
, AP_BANK_ACCOUNTS_ALL BACC
, AR_RECEIPT_METHODS RM
, RA_TERMS TER
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE CT.BATCH_ID = BAT.BATCH_ID (+)
AND CT.BILL_TO_CUSTOMER_ID = BICUST_ACCT.CUST_ACCOUNT_ID (+)
AND BICUST_ACCT.PARTY_ID = BIPARTY.PARTY_ID (+)
AND CT.CUST_TRX_TYPE_ID = CTT.CUST_TRX_TYPE_ID
AND ((CT.CUST_TRX_TYPE_ID IS NULL) OR (CT.CUST_TRX_TYPE_ID IS NOT NULL
AND NVL(CT.ORG_ID
, -12345) = NVL(CTT.ORG_ID
, -12345)))
AND CT.PRIMARY_SALESREP_ID = SAL.SALESREP_ID (+)
AND ((CT.PRIMARY_SALESREP_ID IS NULL) OR (CT.PRIMARY_SALESREP_ID IS NOT NULL
AND NVL(CT.ORG_ID
, -12345) = NVL(SAL.ORG_ID
, -12345)))
AND CT.BILL_TO_SITE_USE_ID = BISU.SITE_USE_ID (+)
AND CT.SHIP_TO_SITE_USE_ID = SISU.SITE_USE_ID (+)
AND CT.SOLD_TO_SITE_USE_ID = SOSU.SITE_USE_ID (+)
AND CT.PAYING_SITE_USE_ID = PASU.SITE_USE_ID (+)
AND CT.CUSTOMER_BANK_ACCOUNT_ID = BACC.BANK_ACCOUNT_ID (+)
AND CT.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID (+)
AND CT.TERM_ID = TER.TERM_ID (+)
AND CT.ORG_ID = AOU.ORGANIZATION_ID (+)
AND CTT.TYPE = 'CM'
AND '_SEC:CT.ORG_ID' IS NOT NULL WITH READ ONLY

Columns

Name
TRANSACTION_ID
TRANSACTION_NUMBER
DOCUMENT_SEQUENCE_NUMBER
TRANSACTION_DATE
CURRENCY_EXCHANGE_RATE
CURRENCY_EXCHANGE_RATE_TYPE
CURRENCY_EXCHANGE_RATE_DATE
"_LA:COMPLETE_FLAG"
"_LA:TRANSACTION_STATUS"
PURCHASE_ORDER_NUMBER
PURCHASE_ORDER_DATE
PURCHASE_ORDER_REVISION
REASON_CODE
REFERENCE_NUMBER
"_LA:FINANCE_CHARGES_FLAG"
DUE_DATE
"_LA:TAX_EXEMPT_FLAG"
FREIGHT_CARRIER
SHIP_DATE
SHIPPING_REFERENCE
"_LA:FOB_POINT"
"_LA:EDI_PROCESSED_FLAG"
FIRST_PRINT_DATE
LAST_PRINT_DATE
"_LA:PENDING_PRINT_FLAG"
PRINTING_COUNT
ORIGINAL_SYSTEM_BATCH_NAME
BATCH_NAME
BILL_TO_CONTACT_NAME
SHIP_TO_CONTACT_NAME
SOLD_TO_CONTACT_NAME
BILL_TO_CUSTOMER
SHIP_TO_CUSTOMER
SOLD_TO_CUSTOMER
PAYING_CUSTOMER
TRANSACTION_TYPE_NAME
SALESPERSON_NAME
BILL_TO_SITE
SHIP_TO_SITE
SOLD_TO_SITE
PAYING_SITE
REMIT_TO_ADDRESS
CUSTOMER_BANK_ACCOUNT_NAME
CUSTOMER_BANK_ACCOUNT_NUMBER
PAYMENT_METHOD
PAYMENT_TERM_NAME
OPERATING_UNIT
"_DF:TRANS_INFO"
"_DF:INVOICE_TRANS"
"_DF:GLOBAL_FLEX"
BATCH_ID
TERM_ID
BILL_TO_CONTACT_ID
SHIP_TO_CONTACT_ID
SOLD_TO_CONTACT_ID
BILL_TO_CUSTOMER_ID
SHIP_TO_CUSTOMER_ID
SOLD_TO_CUSTOMER_ID
PAYING_CUSTOMER_ID
CUST_TRX_TYPE_ID
PRIMARY_SALESREP_ID
BILL_TO_SITE_USE_ID
SHIP_TO_SITE_USE_ID
SOLD_TO_SITE_USE_ID
PAYING_SITE_USE_ID
REMIT_TO_ADDRESS_ID
CUSTOMER_BANK_ACCOUNT_ID
RECEIPT_METHOD_ID
ORG_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
INTERNAL_NOTES
COMMENTS