View: JAI_AR_TRX_DTLS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_AR_TRX_DTLS_V

View Text

SELECT A.TRX_DATE
, A.TRX_NUMBER
, HZP.PARTY_NAME CUSTOMER_NAME
, A.CUSTOMER_TRX_ID
, J.ORGANIZATION_ID
FROM RA_CUSTOMER_TRX_ALL A
, OE_ORDER_HEADERS_ALL B
, JAI_OM_OE_BOND_REG_DTLS C
, JAI_OM_OE_BOND_REG_HDRS D
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, JAI_AR_TRXS J
WHERE A.INTERFACE_HEADER_ATTRIBUTE1 IS NOT NULL
AND LTRIM(RTRIM(A.INTERFACE_HEADER_ATTRIBUTE1)) = LTRIM(RTRIM(TO_CHAR(B.ORDER_NUMBER)))
AND B.ORDER_TYPE_ID = C.ORDER_TYPE_ID
AND C.ORDER_FLAG = 'Y'
AND C.REGISTER_ID = D.REGISTER_ID
AND HZP.PARTY_ID = HZCA.PARTY_ID
AND HZCA.CUST_ACCOUNT_ID = A.SHIP_TO_CUSTOMER_ID
AND J.CUSTOMER_TRX_ID = A.CUSTOMER_TRX_ID
AND (UPPER(D.REGISTER_CODE) LIKE '%EXPORT%' OR UPPER(D.REGISTER_CODE) LIKE '%BOND%') UNION ALL SELECT A.TRX_DATE
, A.TRX_NUMBER
, HZP.PARTY_NAME CUSTOMER_NAME
, A.CUSTOMER_TRX_ID
, J.ORGANIZATION_ID
FROM RA_CUSTOMER_TRX_ALL A
, JAI_OM_OE_BOND_REG_DTLS B
, JAI_OM_OE_BOND_REG_HDRS C
, HZ_PARTIES HZP
, HZ_CUST_ACCOUNTS HZCA
, JAI_AR_TRXS J
WHERE A.INTERFACE_HEADER_ATTRIBUTE1 IS NULL
AND A.BATCH_SOURCE_ID = B.ORDER_TYPE_ID
AND B.ORDER_FLAG = 'N'
AND C.REGISTER_ID = B.REGISTER_ID
AND (UPPER(C.REGISTER_CODE) LIKE '%EXPORT%' OR UPPER(C.REGISTER_CODE) LIKE '%BOND%')
AND HZP.PARTY_ID = HZCA.PARTY_ID
AND HZCA.CUST_ACCOUNT_ID= A.SHIP_TO_CUSTOMER_ID
AND J.CUSTOMER_TRX_ID = A.CUSTOMER_TRX_ID

Columns