VIEW: APPS.INL_ADJ_ASSOCIATIONS_V

Source

View Text - Preformatted

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 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

View Text - HTML Formatted

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
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