eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.INL_ALLOCATIONS_V

Source

View Text - Preformatted


SELECT A.ALLOCATION_ID, A.SHIP_HEADER_ID, A.ASSOCIATION_ID, A.PARENT_ALLOCATION_ID, A.FROM_PARENT_TABLE_NAME, A.FROM_PARENT_TABLE_ID, A.TO_PARENT_TABLE_NAME, A.TO_PARENT_TABLE_ID, A.SHIP_LINE_ID, A.ADJUSTMENT_NUM, (SELECT SUM(NVL(IA.ALLOCATION_AMT,0)) FROM INL_ALLOCATIONS IA, INL_SHIP_LINES_ALL IC WHERE IC.SHIP_LINE_ID = IA.SHIP_LINE_ID AND IC.SHIP_LINE_ID = B.PARENT_SHIP_LINE_ID AND IA.ADJUSTMENT_NUM = 0 AND (IA.ALLOCATION_ID = A.ALLOCATION_ID OR (IA.ADJUSTMENT_NUM <> A.ADJUSTMENT_NUM AND IA.ALLOCATION_ID = A.PARENT_ALLOCATION_ID))) AS ESTIMATED_AMT, A.ALLOCATION_AMT, A.LANDED_COST_FLAG, A.CREATED_BY, A.CREATION_DATE, A.LAST_UPDATED_BY, A.LAST_UPDATE_DATE, A.LAST_UPDATE_LOGIN  FROM INL_ALLOCATIONS A, (SELECT ALLOCATION_ID, NVL(CC.PARENT_SHIP_LINE_ID, CC.SHIP_LINE_ID) AS PARENT_SHIP_LINE_ID FROM INL_ALLOCATIONS CA, INL_SHIP_LINES_ALL CC WHERE CC.SHIP_LINE_ID = CA.SHIP_LINE_ID AND CC.SHIP_HEADER_ID = CA.SHIP_HEADER_ID) B WHERE B.ALLOCATION_ID = A.ALLOCATION_ID AND A.LANDED_COST_FLAG = 'Y'

View Text - HTML Formatted

SELECT A.ALLOCATION_ID
, A.SHIP_HEADER_ID
, A.ASSOCIATION_ID
, A.PARENT_ALLOCATION_ID
, A.FROM_PARENT_TABLE_NAME
, A.FROM_PARENT_TABLE_ID
, A.TO_PARENT_TABLE_NAME
, A.TO_PARENT_TABLE_ID
, A.SHIP_LINE_ID
, A.ADJUSTMENT_NUM
, (SELECT SUM(NVL(IA.ALLOCATION_AMT
, 0))
FROM INL_ALLOCATIONS IA
, INL_SHIP_LINES_ALL IC
WHERE IC.SHIP_LINE_ID = IA.SHIP_LINE_ID
AND IC.SHIP_LINE_ID = B.PARENT_SHIP_LINE_ID
AND IA.ADJUSTMENT_NUM = 0
AND (IA.ALLOCATION_ID = A.ALLOCATION_ID OR (IA.ADJUSTMENT_NUM <> A.ADJUSTMENT_NUM
AND IA.ALLOCATION_ID = A.PARENT_ALLOCATION_ID))) AS ESTIMATED_AMT
, A.ALLOCATION_AMT
, A.LANDED_COST_FLAG
, A.CREATED_BY
, A.CREATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM INL_ALLOCATIONS A
, (SELECT ALLOCATION_ID
, NVL(CC.PARENT_SHIP_LINE_ID
, CC.SHIP_LINE_ID) AS PARENT_SHIP_LINE_ID
FROM INL_ALLOCATIONS CA
, INL_SHIP_LINES_ALL CC
WHERE CC.SHIP_LINE_ID = CA.SHIP_LINE_ID
AND CC.SHIP_HEADER_ID = CA.SHIP_HEADER_ID) B
WHERE B.ALLOCATION_ID = A.ALLOCATION_ID
AND A.LANDED_COST_FLAG = 'Y'