VIEW: APPS.RA_CUSTOMER_TRX_FRT_V

Source

View Text - Preformatted

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(+) /*6650397 */ 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')

View Text - HTML Formatted

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(+) /*6650397 */
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')