[Home] [Help]
View: INL_ADJ_ASSOCIATIONS_V
Product: | INL - Oracle Landed Cost Management |
Description: | This view shows adjusted associations between landed cost components of the same or different Shipments. |
Implementation/DBA Data: |
APPS.INL_ADJ_ASSOCIATIONS_V
|
View Text
SELECT A.ASSOCIATION_ID
, A.SHIP_HEADER_ID
, A.FROM_PARENT_TABLE_NAME
, DECODE(A.FROM_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT SHIP_LINE_ID
FROM INL_ADJ_SHIP_LINES_V SL
FROM INL_ADJ_SHIP_LINES_V3 SL
WHERE (NVL(SL.PARENT_SHIP_LINE_ID
, SL.SHIP_LINE_ID) = A.FROM_PARENT_TABLE_ID OR SL.SHIP_LINE_ID IN (SELECT C2.SHIP_LINE_ID
FROM INL_SHIP_LINES C2
WHERE CONNECT_BY_ISLEAF = 1 START WITH C2.SHIP_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR SHIP_LINE_ID = PARENT_SHIP_LINE_ID ) )
AND ROWNUM < 2)
, 'INL_CHARGE_LINES'
, (SELECT CHARGE_LINE_ID
FROM INL_ADJ_CHARGE_LINES_V CL
WHERE (NVL(CL.PARENT_CHARGE_LINE_ID
, CL.CHARGE_LINE_ID) = A.FROM_PARENT_TABLE_ID OR CL.CHARGE_LINE_ID IN (SELECT C2.CHARGE_LINE_ID
FROM INL_CHARGE_LINES C2
WHERE CONNECT_BY_ISLEAF = 1 START WITH C2.CHARGE_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR CHARGE_LINE_ID = PARENT_CHARGE_LINE_ID ) )
AND ROWNUM < 2)
, 'INL_TAX_LINES'
, (SELECT TAX_LINE_ID
FROM INL_ADJ_TAX_LINES_V TL
WHERE (NVL(TL.PARENT_TAX_LINE_ID
, TL.TAX_LINE_ID) = A.FROM_PARENT_TABLE_ID OR TL.TAX_LINE_ID IN (SELECT TL2.TAX_LINE_ID
FROM INL_TAX_LINES TL2
WHERE CONNECT_BY_ISLEAF = 1 START WITH TL2.TAX_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR TAX_LINE_ID = PARENT_TAX_LINE_ID ) )
AND ROWNUM < 2)
, A.FROM_PARENT_TABLE_ID ) FROM_PARENT_TABLE_ID
, A.TO_PARENT_TABLE_NAME
, DECODE(A.TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT SHIP_LINE_ID
FROM INL_ADJ_SHIP_LINES_V SL
WHERE NVL(SL.PARENT_SHIP_LINE_ID
, SL.SHIP_LINE_ID) = A.TO_PARENT_TABLE_ID
AND ROWNUM < 2)
, 'INL_CHARGE_LINES'
, (SELECT CHARGE_LINE_ID
FROM INL_ADJ_CHARGE_LINES_V CL
WHERE NVL(CL.PARENT_CHARGE_LINE_ID
, CL.CHARGE_LINE_ID) = A.TO_PARENT_TABLE_ID
AND ROWNUM < 2)
, A.TO_PARENT_TABLE_ID) TO_PARENT_TABLE_ID
, A.ALLOCATION_BASIS
, A.ALLOCATION_UOM_CODE
FROM INL_ASSOCIATIONS A
Columns
Name |
ASSOCIATION_ID |
SHIP_HEADER_ID |
FROM_PARENT_TABLE_NAME |
FROM_PARENT_TABLE_ID |
TO_PARENT_TABLE_NAME |
TO_PARENT_TABLE_ID |
ALLOCATION_BASIS |
ALLOCATION_UOM_CODE |