View: RA_CUSTOMER_TRX_FRT_V

Product:	AR - Receivables
Description:	(Release 115 Only)
Implementation/DBA Data:	APPS.RA_CUSTOMER_TRX_FRT_V

View Text

SELECT CT.ROWID
, CT.CUSTOMER_TRX_ID
, CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.CUST_TRX_TYPE_ID
, CT.PRIMARY_SALESREP_ID
, OF_SHIP_VIA.DESCRIPTION
, CT.SHIP_DATE_ACTUAL
, CT.WAYBILL_NUMBER
, AL_FOB.MEANING
, CT.SHIP_VIA
, CT.FOB_POINT
, DECODE(AL_FRT_TYPE.LOOKUP_CODE
, 'LINE'
, 'L'
, 'HEADER'
, 'H'
, NULL)
, CT.LAST_UPDATE_DATE
, CT.LAST_UPDATED_BY
, CT.CREATION_DATE
, CT.CREATED_BY
, CT.LAST_UPDATE_LOGIN
FROM RA_CUSTOMER_TRX CT
, AR_LOOKUPS AL_FRT_TYPE
, AR_LOOKUPS AL_FOB
, ORG_FREIGHT OF_SHIP_VIA
, OE_SYSTEM_PARAMETERS OS
WHERE CT.SHIP_VIA = OF_SHIP_VIA.FREIGHT_CODE (+)
AND OF_SHIP_VIA.ORGANIZATION_ID = OS.MASTER_ORGANIZATION_ID(+)
AND CT.FOB_POINT = AL_FOB.LOOKUP_CODE(+)
AND 'FOB' = AL_FOB.LOOKUP_TYPE(+)
AND AL_FRT_TYPE.LOOKUP_TYPE = 'FREIGHT_TYPE'
AND AL_FRT_TYPE.LOOKUP_CODE = ( SELECT DECODE(MAX(CTL.CUSTOMER_TRX_LINE_ID)
, NULL
, 'NONE'
, DECODE(MAX(CTL.LINK_TO_CUST_TRX_LINE_ID)
, NULL
, 'HEADER'
, 'LINE'))
FROM RA_CUSTOMER_TRX_LINES CTL
WHERE CTL.CUSTOMER_TRX_ID = NVL(CT.PREVIOUS_CUSTOMER_TRX_ID
, CT.CUSTOMER_TRX_ID)
AND CTL.LINE_TYPE = 'FREIGHT')

Columns