VIEW: APPS.INL_ADJ_ASSOCIATIONS_V

Source

View Text - Preformatted

SELECT a.association_id association_id, a.ship_header_id ship_header_id, a.from_parent_table_name from_parent_table_name, DECODE (a.from_parent_table_name, 'INL_SHIP_LINES',(SELECT MAX(sl.ship_line_id) FROM inl_ship_lines_all sl WHERE CONNECT_BY_ISLEAF = 1 START WITH sl.ship_line_id = a.from_parent_table_id CONNECT BY PRIOR sl.ship_line_id = sl.parent_ship_line_id), 'INL_CHARGE_LINES',(SELECT MAX(cl.charge_line_id) FROM inl_charge_lines cl WHERE CONNECT_BY_ISLEAF = 1 START WITH cl.charge_line_id = a.from_parent_table_id CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id), 'INL_TAX_LINES',(SELECT MAX(tl.tax_line_id) FROM inl_tax_lines tl WHERE CONNECT_BY_ISLEAF = 1 START WITH tl.tax_line_id = a.from_parent_table_id CONNECT BY PRIOR tl.tax_line_id = tl.parent_tax_line_id), a.from_parent_table_id) from_parent_table_id, a.to_parent_table_name, DECODE(a.to_parent_table_name, 'INL_SHIP_LINES',(SELECT MAX(sl.ship_line_id) FROM inl_ship_lines_all sl WHERE CONNECT_BY_ISLEAF = 1 START WITH sl.ship_line_id = a.to_parent_table_id CONNECT BY PRIOR sl.ship_line_id = sl.parent_ship_line_id), 'INL_CHARGE_LINES',(SELECT MAX(cl.charge_line_id) FROM inl_charge_lines cl WHERE CONNECT_BY_ISLEAF = 1 START WITH cl.charge_line_id = a.to_parent_table_id CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id), a.to_parent_table_id) to_parent_table_id, a.allocation_basis allocation_basis, a.allocation_uom_code allocation_uom_code, a.adjustment_type_flag adjustment_type_flag FROM inl_associations a

View Text - HTML Formatted

SELECT A.ASSOCIATION_ID ASSOCIATION_ID
, A.SHIP_HEADER_ID SHIP_HEADER_ID
, A.FROM_PARENT_TABLE_NAME FROM_PARENT_TABLE_NAME
, DECODE (A.FROM_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT MAX(SL.SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL SL
WHERE CONNECT_BY_ISLEAF = 1 START WITH SL.SHIP_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR SL.SHIP_LINE_ID = SL.PARENT_SHIP_LINE_ID)
, 'INL_CHARGE_LINES'
, (SELECT MAX(CL.CHARGE_LINE_ID)
FROM INL_CHARGE_LINES CL
WHERE CONNECT_BY_ISLEAF = 1 START WITH CL.CHARGE_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR CL.CHARGE_LINE_ID = CL.PARENT_CHARGE_LINE_ID)
, 'INL_TAX_LINES'
, (SELECT MAX(TL.TAX_LINE_ID)
FROM INL_TAX_LINES TL
WHERE CONNECT_BY_ISLEAF = 1 START WITH TL.TAX_LINE_ID = A.FROM_PARENT_TABLE_ID CONNECT BY PRIOR TL.TAX_LINE_ID = TL.PARENT_TAX_LINE_ID)
, A.FROM_PARENT_TABLE_ID) FROM_PARENT_TABLE_ID
, A.TO_PARENT_TABLE_NAME
, DECODE(A.TO_PARENT_TABLE_NAME
, 'INL_SHIP_LINES'
, (SELECT MAX(SL.SHIP_LINE_ID)
FROM INL_SHIP_LINES_ALL SL
WHERE CONNECT_BY_ISLEAF = 1 START WITH SL.SHIP_LINE_ID = A.TO_PARENT_TABLE_ID CONNECT BY PRIOR SL.SHIP_LINE_ID = SL.PARENT_SHIP_LINE_ID)
, 'INL_CHARGE_LINES'
, (SELECT MAX(CL.CHARGE_LINE_ID)
FROM INL_CHARGE_LINES CL
WHERE CONNECT_BY_ISLEAF = 1 START WITH CL.CHARGE_LINE_ID = A.TO_PARENT_TABLE_ID CONNECT BY PRIOR CL.CHARGE_LINE_ID = CL.PARENT_CHARGE_LINE_ID)
, A.TO_PARENT_TABLE_ID) TO_PARENT_TABLE_ID
, A.ALLOCATION_BASIS ALLOCATION_BASIS
, A.ALLOCATION_UOM_CODE ALLOCATION_UOM_CODE
, A.ADJUSTMENT_TYPE_FLAG ADJUSTMENT_TYPE_FLAG
FROM INL_ASSOCIATIONS A