Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.ARFV_FREIGHT_CHARGES |
SELECT /* UNIQUE ATTRIBUTES */ CTL.CUSTOMER_TRX_LINE_ID
, /* REGULAR ATTRIBUTES */ CTL.EXTENDED_AMOUNT
, '_LA:CTL.REASON_CODE:AR_LOOKUPS:INVOICING_REASON:MEANING'
, CT.SHIP_VIA
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, '_LA:CT.FOB_POINT:AR_LOOKUPS:FOB:MEANING'
, /* RESOLVED FK RESOLUTIONS */ CT.TRX_NUMBER
, CRCT.TRX_NUMBER
, CRCTL.LINE_NUMBER
, COCT.TRX_NUMBER
, COCTL.LINE_NUMBER
, AOU.NAME
, '_DF:AR:RA_CUSTOMER_TRX_LINES:CTL'
, '_DF:AR:RA_INTERFACE_LINES:CTL'
, '_DF:JG:JG_RA_CUSTOMER_TRX_LINES:CTL'
, /* IDS */ CTL.CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_ID
, CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID
, CTL.INITIAL_CUSTOMER_TRX_LINE_ID
, CTL.LINK_TO_CUST_TRX_LINE_ID
, CTL.ORG_ID
, /* WHO COLUMNS */ CTL.LAST_UPDATE_DATE
, CTL.LAST_UPDATED_BY
, CTL.CREATION_DATE
, CTL.CREATED_BY
FROM RA_CUSTOMER_TRX_LINES CTL
, RA_CUSTOMER_TRX CT
, RA_CUSTOMER_TRX CRCT
, RA_CUSTOMER_TRX_LINES CRCTL
, RA_CUSTOMER_TRX COCT
, RA_CUSTOMER_TRX_LINES COCTL
, HR_ALL_ORGANIZATION_UNITS AOU
WHERE CTL.CUSTOMER_TRX_ID = CT.CUSTOMER_TRX_ID
AND CTL.PREVIOUS_CUSTOMER_TRX_ID = CRCT.CUSTOMER_TRX_ID(+)
AND CTL.PREVIOUS_CUSTOMER_TRX_LINE_ID = CRCTL.CUSTOMER_TRX_LINE_ID (+)
AND CTL.INITIAL_CUSTOMER_TRX_LINE_ID = COCTL.CUSTOMER_TRX_LINE_ID (+)
AND COCTL.CUSTOMER_TRX_ID = COCT.CUSTOMER_TRX_ID (+)
AND CTL.ORG_ID = AOU.ORGANIZATION_ID (+)
AND CTL.LINE_TYPE = 'FREIGHT' WITH READ ONLY