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.

APPS.INL_LANDEDCOST_PVT dependencies on INL_ASSOCIATIONS

Line 79: FROM inl_associations

75: PRAGMA EXCEPTION_INIT(LOOP_ERROR, -1436);
76: BEGIN
77: SELECT count(*)
78: INTO l_count
79: FROM inl_associations
80: WHERE ship_header_id = p_ship_header_id
81: START WITH FROM_PARENT_TABLE_NAME = P_from_parent_table_name
82: AND FROM_PARENT_TABLE_ID = P_from_parent_table_id
83: CONNECT BY PRIOR TO_PARENT_TABLE_NAME = FROM_PARENT_TABLE_NAME

Line 830: FROM inl_associations a

826: START WITH cl.charge_line_id = a.to_parent_table_id
827: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
828: ),
829: a.to_parent_table_id) to_parent_table_id
830: FROM inl_associations a
831: WHERE a.from_parent_table_name = p_from_component_name
832: AND a.from_parent_table_id
833: = DECODE(a.from_parent_table_name,
834: 'INL_CHARGE_LINES',

Line 1723: FROM inl_associations a

1719: a.to_parent_table_id ship_line_id
1720: /* SCM-LCM-010
1721: FROM inl_adj_associations_v a
1722: */
1723: FROM inl_associations a
1724: WHERE a.from_parent_table_name = 'INL_SHIP_LINES'
1725: AND a.from_parent_table_id =
1726: (SELECT MIN(sl.ship_line_id)
1727: FROM inl_ship_lines sl

Line 1852: FROM inl_associations a

1848: p_debug_info => l_debug_info);
1849:
1850: SELECT COUNT(*)
1851: INTO l_count
1852: FROM inl_associations a
1853: WHERE a.from_parent_table_name = 'INL_SHIP_LINES'
1854: AND a.to_parent_table_name = 'INL_SHIP_LINES'
1855: AND a.ship_header_id = p_ship_header_id;
1856:

Line 2538: FROM inl_associations a

2534: START WITH cl.charge_line_id = a.to_parent_table_id
2535: CONNECT BY PRIOR cl.charge_line_id = cl.parent_charge_line_id
2536: ),
2537: a.to_parent_table_id) to_parent_table_id
2538: FROM inl_associations a
2539: WHERE a.ship_header_id = p_ship_header_id
2540: AND a.from_parent_table_name = pc_component_name
2541: AND a.from_parent_table_id = pc_component_id
2542: ORDER BY a.association_id;

Line 3095: FROM inl_associations a

3091: a.to_parent_table_id) to_parent_table_id,
3092: a.allocation_basis,
3093: a.allocation_uom_code,
3094: a.association_id
3095: FROM inl_associations a
3096: WHERE DECODE(a.from_parent_table_name,
3097: 'INL_SHIP_LINES',
3098: (SELECT MAX(sl.ship_line_id)
3099: FROM inl_ship_lines_all sl,

Line 3181: FROM inl_associations a

3177: FROM inl_charge_lines c,
3178: --Bug#13988746 BEG
3179: (
3180: SELECT DISTINCT a.from_parent_table_id
3181: FROM inl_associations a
3182: WHERE a.from_parent_table_name = 'INL_CHARGE_LINES'
3183: AND a.ship_header_id = p_ship_header_id
3184: ) X
3185: --Bug#13988746 END

Line 3201: FROM inl_associations x

3197: )
3198: --- SCM-051
3199: /*
3200: AND EXISTS (SELECT 'x'
3201: FROM inl_associations x
3202: WHERE x.from_parent_table_name = 'INL_CHARGE_LINES'
3203: AND (SELECT MAX(cl.charge_line_id)
3204: FROM inl_charge_lines cl
3205: --- SCM-051

Line 3229: FROM inl_associations x

3225: --- WHERE t.adjustment_num <= pc_adjustment_num --Bug#9660084
3226: WHERE ABS(t.adjustment_num) <= ABS(pc_adjustment_num) --Bug#9660084
3227: --- SCM-051
3228: AND EXISTS (SELECT 'x'
3229: FROM inl_associations x
3230: WHERE x.from_parent_table_name = 'INL_TAX_LINES'
3231: AND (SELECT MAX(tl.tax_line_id)
3232: FROM inl_tax_lines tl
3233: --- SCM-051

Line 3455: FROM inl_associations a

3451: UNION ALL
3452: SELECT sl.adjustment_num adjustment_num
3453: FROM inl_ship_lines_all sl
3454: WHERE EXISTS (SELECT 'X'
3455: FROM inl_associations a
3456: WHERE a.ship_header_id = p_ship_header_id
3457: AND a.from_parent_table_name = 'INL_SHIP_LINES'
3458: AND a.from_parent_table_id = sl.ship_line_id)
3459: UNION ALL

Line 3463: FROM inl_associations a

3459: UNION ALL
3460: SELECT cl.adjustment_num adjustment_num
3461: FROM inl_charge_lines cl
3462: WHERE EXISTS (SELECT 'X'
3463: FROM inl_associations a
3464: WHERE a.ship_header_id = p_ship_header_id
3465: AND a.from_parent_table_name = 'INL_CHARGE_LINES'
3466: AND a.from_parent_table_id = cl.charge_line_id)
3467: UNION ALL

Line 3471: FROM inl_associations a

3467: UNION ALL
3468: SELECT tl.adjustment_num adjustment_num
3469: FROM inl_tax_lines tl
3470: WHERE EXISTS (SELECT 'X'
3471: FROM inl_associations a
3472: WHERE a.ship_header_id = p_ship_header_id
3473: AND a.from_parent_table_name = 'INL_TAX_LINES'
3474: AND a.from_parent_table_id = tl.tax_line_id)) x
3475: --- SCM-051

Line 3508: inl_associations a,

3504: )
3505: )) adj_num
3506: INTO l_current_adjustment_num
3507: FROM
3508: inl_associations a,
3509: inl_ship_headers_all sh
3510: WHERE a.ship_header_id(+) = sh.ship_header_id
3511: AND sh.ship_header_id = p_ship_header_id
3512: ;

Line 3874: FROM inl_associations

3870: p_debug_info => l_debug_info);
3871:
3872: SELECT COUNT(*) + l_count1
3873: INTO l_count1
3874: FROM inl_associations
3875: WHERE from_parent_table_name = 'INL_SHIP_LINES'
3876: AND from_parent_table_id = dist_List(iDist).ship_line_id;
3877:
3878: SELECT COUNT(*) + l_count1

Line 3880: FROM inl_associations

3876: AND from_parent_table_id = dist_List(iDist).ship_line_id;
3877:
3878: SELECT COUNT(*) + l_count1
3879: INTO l_count1
3880: FROM inl_associations
3881: WHERE from_parent_table_name = 'INL_SHIP_HEADERS'
3882: AND from_parent_table_id = dist_List(iDist).ship_header_id;
3883:
3884: --Bug#9660084

Line 3914: inl_associations assoc,

3910: SELECT SUM(NVL(al.allocation_amt,0))
3911: INTO l_inclusive_tax_amt
3912: FROM
3913: inl_tax_lines t, --BUG#8330505
3914: inl_associations assoc,
3915: inl_allocations al
3916: WHERE t.tax_amt_included_flag = 'Y'
3917: AND t.tax_line_id = (SELECT MAX(tl.tax_line_id)
3918: FROM inl_tax_lines tl