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_SHIP_LINES_ALL

Line 807: FROM inl_ship_lines_all sl,

803: a.to_parent_table_name,
804: DECODE(a.to_parent_table_name,
805: 'INL_SHIP_LINES',
806: (SELECT MAX(sl.ship_line_id)
807: FROM inl_ship_lines_all sl,
808: inl_ship_lines_all sl0
809: WHERE sl0.ship_line_id = a.to_parent_table_id
810: AND sl.ship_header_id = sl0.ship_header_id
811: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 808: inl_ship_lines_all sl0

804: DECODE(a.to_parent_table_name,
805: 'INL_SHIP_LINES',
806: (SELECT MAX(sl.ship_line_id)
807: FROM inl_ship_lines_all sl,
808: inl_ship_lines_all sl0
809: WHERE sl0.ship_line_id = a.to_parent_table_id
810: AND sl.ship_header_id = sl0.ship_header_id
811: AND sl.ship_line_group_id = sl0.ship_line_group_id
812: AND sl.ship_line_num = sl0.ship_line_num

Line 906: FROM inl_ship_lines_all ol

902: IF assoc_List(1).to_parent_table_name = 'INL_SHIP_HEADERS' THEN
903: SELECT
904: COUNT(*)
905: INTO l_count_aux
906: FROM inl_ship_lines_all ol
907: WHERE ol.ship_header_id = assoc_List(1).to_parent_table_id
908: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
909: FROM inl_ship_lines_all sl
910: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 909: FROM inl_ship_lines_all sl

905: INTO l_count_aux
906: FROM inl_ship_lines_all ol
907: WHERE ol.ship_header_id = assoc_List(1).to_parent_table_id
908: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
909: FROM inl_ship_lines_all sl
910: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
911: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
912: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
913: --- SCM-051

Line 930: FROM inl_ship_lines_all ol

926: ELSIF assoc_List(1).to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
927: SELECT
928: COUNT(*)
929: INTO l_count_aux
930: FROM inl_ship_lines_all ol
931: WHERE ol.ship_line_group_id = assoc_List(1).to_parent_table_id
932: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
933: FROM inl_ship_lines_all sl
934: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 933: FROM inl_ship_lines_all sl

929: INTO l_count_aux
930: FROM inl_ship_lines_all ol
931: WHERE ol.ship_line_group_id = assoc_List(1).to_parent_table_id
932: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
933: FROM inl_ship_lines_all sl
934: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
935: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
936: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
937: --- SCM-051

Line 954: FROM inl_ship_lines_all ol

950:
951: SELECT
952: COUNT(*)
953: INTO l_count_aux
954: FROM inl_ship_lines_all ol
955: WHERE ol.ship_header_id = DECODE(p_from_component_name,'INL_SHIP_HEADERS',p_from_component_id,ol.ship_header_id)
956: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
957: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)
958: AND ol.ship_header_id = p_ship_header_id

Line 960: FROM inl_ship_lines_all sl

956: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
957: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)
958: AND ol.ship_header_id = p_ship_header_id
959: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
960: FROM inl_ship_lines_all sl
961: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
962: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
963: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
964: --- SCM-051

Line 1073: FROM inl_ship_lines_all ol

1069: p_allocation_uom_code))) + l_total_amt,
1070: COUNT(*) + l_count
1071: INTO l_total_amt,
1072: l_count
1073: FROM inl_ship_lines_all ol
1074: WHERE ol.ship_header_id = assoc_List(iAssoc).to_parent_table_id
1075: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1076: FROM inl_ship_lines_all sl
1077: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 1076: FROM inl_ship_lines_all sl

1072: l_count
1073: FROM inl_ship_lines_all ol
1074: WHERE ol.ship_header_id = assoc_List(iAssoc).to_parent_table_id
1075: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1076: FROM inl_ship_lines_all sl
1077: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
1078: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
1079: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
1080: --- SCM-051

Line 1110: FROM inl_ship_lines_all ol

1106: p_allocation_uom_code))) + l_total_amt,
1107: COUNT(*) + l_count
1108: INTO l_total_amt,
1109: l_count
1110: FROM inl_ship_lines_all ol
1111: WHERE ol.ship_line_group_id = assoc_List(iAssoc).to_parent_table_id
1112: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1113: FROM inl_ship_lines_all sl
1114: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 1113: FROM inl_ship_lines_all sl

1109: l_count
1110: FROM inl_ship_lines_all ol
1111: WHERE ol.ship_line_group_id = assoc_List(iAssoc).to_parent_table_id
1112: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1113: FROM inl_ship_lines_all sl
1114: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
1115: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
1116: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
1117: --- SCM-051

Line 1147: FROM inl_ship_lines_all ol

1143: p_allocation_uom_code))) + l_total_amt,
1144: COUNT(*) + l_count
1145: INTO l_total_amt,
1146: l_count
1147: FROM inl_ship_lines_all ol
1148: WHERE ol.ship_line_id = assoc_List(iAssoc).to_parent_table_id;
1149:
1150: l_debug_info := 'C-l_total_amt';
1151: INL_LOGGING_PVT.Log_Variable (

Line 1246: FROM inl_ship_lines_all ol

1242: p_allocation_uom_code))) + l_total_amt,
1243: COUNT(*)
1244: INTO l_total_amt,
1245: l_count
1246: FROM inl_ship_lines_all ol
1247: WHERE ol.ship_header_id = DECODE(p_from_component_name,'INL_SHIP_HEADERS',p_from_component_id,ol.ship_header_id)
1248: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
1249: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)
1250: AND ol.ship_header_id = p_ship_header_id

Line 1252: FROM inl_ship_lines_all sl

1248: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
1249: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)
1250: AND ol.ship_header_id = p_ship_header_id
1251: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1252: FROM inl_ship_lines_all sl
1253: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
1254: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
1255: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
1256: --- SCM-051

Line 1483: FROM inl_ship_lines_all ol

1479: NVL(ol.primary_qty,0),
1480: ol.primary_uom_code,
1481: p_allocation_uom_code)))
1482: INTO l_to_component_amt
1483: FROM inl_ship_lines_all ol
1484: WHERE ol.ship_header_id = p_to_component_id
1485: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1486: FROM inl_ship_lines_all sl
1487: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 1486: FROM inl_ship_lines_all sl

1482: INTO l_to_component_amt
1483: FROM inl_ship_lines_all ol
1484: WHERE ol.ship_header_id = p_to_component_id
1485: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1486: FROM inl_ship_lines_all sl
1487: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
1488: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
1489: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
1490: --- SCM-051

Line 1504: FROM inl_ship_lines_all ol

1500: NVL(ol.primary_qty,0),
1501: ol.primary_uom_code,
1502: p_allocation_uom_code)))
1503: INTO l_to_component_amt
1504: FROM inl_ship_lines_all ol
1505: WHERE ol.ship_line_group_id = p_to_component_id
1506: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1507: FROM inl_ship_lines_all sl
1508: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 1507: FROM inl_ship_lines_all sl

1503: INTO l_to_component_amt
1504: FROM inl_ship_lines_all ol
1505: WHERE ol.ship_line_group_id = p_to_component_id
1506: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
1507: FROM inl_ship_lines_all sl
1508: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
1509: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
1510: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
1511: --- SCM-051

Line 1525: FROM inl_ship_lines_all ol

1521: NVL(ol.primary_qty,0),
1522: ol.primary_uom_code,
1523: p_allocation_uom_code)))
1524: INTO l_to_component_amt
1525: FROM inl_ship_lines_all ol
1526: WHERE ol.ship_line_id = p_to_component_id;
1527: ELSIF p_to_component_name = 'INL_SHIP_DISTS' THEN
1528: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0),0),
1529: Converted_Qty (l_inv_org_id,

Line 1535: FROM inl_ship_lines_all ol

1531: NVL(ol.primary_qty,0),
1532: ol.primary_uom_code,
1533: p_allocation_uom_code)))
1534: INTO l_to_component_amt
1535: FROM inl_ship_lines_all ol
1536: WHERE ol.ship_line_id = p_to_component_id;
1537: ELSIF p_to_component_name = 'INL_CHARGE_LINES' THEN
1538: IF l_allocation_basis = 'VALUE' THEN
1539: SELECT SUM(NVL(charge_amt,0) * NVL(currency_conversion_rate,1))

Line 1691: FROM inl_ship_lines_all sl,

1687: CURSOR assoc IS
1688: SELECT a.association_id,
1689: a.from_parent_table_name,
1690: (SELECT max(sl.ship_line_id)
1691: FROM inl_ship_lines_all sl,
1692: inl_ship_lines_all sl0
1693: WHERE sl0.ship_line_id = a.from_parent_table_id
1694: AND sl.ship_header_id = sl0.ship_header_id
1695: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 1692: inl_ship_lines_all sl0

1688: SELECT a.association_id,
1689: a.from_parent_table_name,
1690: (SELECT max(sl.ship_line_id)
1691: FROM inl_ship_lines_all sl,
1692: inl_ship_lines_all sl0
1693: WHERE sl0.ship_line_id = a.from_parent_table_id
1694: AND sl.ship_header_id = sl0.ship_header_id
1695: AND sl.ship_line_group_id = sl0.ship_line_group_id
1696: AND sl.ship_line_num = sl0.ship_line_num

Line 1705: FROM inl_ship_lines_all sl,

1701: OR sl.ship_header_id <> p_ship_header_id) --Bug#10221931*
1702: ) from_parent_table_id,
1703: a.to_parent_table_name,
1704: (SELECT max(sl.ship_line_id)
1705: FROM inl_ship_lines_all sl,
1706: inl_ship_lines_all sl0
1707: WHERE sl0.ship_line_id = a.to_parent_table_id
1708: AND sl.ship_header_id = sl0.ship_header_id
1709: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 1706: inl_ship_lines_all sl0

1702: ) from_parent_table_id,
1703: a.to_parent_table_name,
1704: (SELECT max(sl.ship_line_id)
1705: FROM inl_ship_lines_all sl,
1706: inl_ship_lines_all sl0
1707: WHERE sl0.ship_line_id = a.to_parent_table_id
1708: AND sl.ship_header_id = sl0.ship_header_id
1709: AND sl.ship_line_group_id = sl0.ship_line_group_id
1710: AND sl.ship_line_num = sl0.ship_line_num

Line 2112: FROM inl_ship_lines_all ol

2108: ) IS
2109: /*
2110: CURSOR dist IS
2111: SELECT ship_line_id
2112: FROM inl_ship_lines_all ol
2113: WHERE ol.ship_header_id = p_ship_header_id
2114: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, ol.ship_line_id)
2115: AND ol.ship_line_group_id = DECODE(p_to_component_name, 'INL_SHIP_LINE_GROUPS', p_to_component_id, ol.ship_line_group_id)
2116: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)

Line 2117: FROM inl_ship_lines_all sl

2113: WHERE ol.ship_header_id = p_ship_header_id
2114: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, ol.ship_line_id)
2115: AND ol.ship_line_group_id = DECODE(p_to_component_name, 'INL_SHIP_LINE_GROUPS', p_to_component_id, ol.ship_line_group_id)
2116: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2117: FROM inl_ship_lines_all sl
2118: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
2119: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
2120: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
2121: AND (sl.adjustment_num <= p_adjustment_num

Line 2129: FROM inl_ship_lines_all ol

2125: ORDER BY ol.ship_line_id;
2126: */
2127: CURSOR dist IS -- this cursor will be open only for p_to_component_name in 'INL_SHIP_LINE_GROUPS', 'INL_SHIP_HEADERS'
2128: SELECT ship_line_id
2129: FROM inl_ship_lines_all ol
2130: WHERE ol.ship_header_id = p_ship_header_id
2131: AND ol.ship_line_group_id = DECODE(p_to_component_name, 'INL_SHIP_LINE_GROUPS', p_to_component_id, ol.ship_line_group_id)
2132: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2133: FROM inl_ship_lines_all sl

Line 2133: FROM inl_ship_lines_all sl

2129: FROM inl_ship_lines_all ol
2130: WHERE ol.ship_header_id = p_ship_header_id
2131: AND ol.ship_line_group_id = DECODE(p_to_component_name, 'INL_SHIP_LINE_GROUPS', p_to_component_id, ol.ship_line_group_id)
2132: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2133: FROM inl_ship_lines_all sl
2134: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
2135: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
2136: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
2137: --- SCM-051

Line 2430: FROM inl_ship_lines_all ol

2426: CURSOR component IS
2427: SELECT 1 SEQ_NUM,
2428: 'INL_SHIP_LINES' COMPONENT_NAME,
2429: ol.ship_line_id COMPONENT_ID
2430: FROM inl_ship_lines_all ol
2431: WHERE ol.ship_header_id = p_ship_header_id
2432: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
2433: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2434: FROM inl_ship_lines_all sl

Line 2434: FROM inl_ship_lines_all sl

2430: FROM inl_ship_lines_all ol
2431: WHERE ol.ship_header_id = p_ship_header_id
2432: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
2433: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2434: FROM inl_ship_lines_all sl
2435: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
2436: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
2437: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
2438: --- SCM-051

Line 2448: FROM inl_ship_lines_all ol

2444: UNION
2445: SELECT 2 SEQ_NUM,
2446: 'INL_SHIP_HEADERS' COMPONENT_NAME,
2447: ol.ship_header_id COMPONENT_ID
2448: FROM inl_ship_lines_all ol
2449: WHERE ol.ship_header_id = p_ship_header_id
2450: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
2451: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2452: FROM inl_ship_lines_all sl

Line 2452: FROM inl_ship_lines_all sl

2448: FROM inl_ship_lines_all ol
2449: WHERE ol.ship_header_id = p_ship_header_id
2450: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
2451: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
2452: FROM inl_ship_lines_all sl
2453: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
2454: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
2455: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
2456: --- SCM-051

Line 2478: FROM inl_ship_lines_all sl,

2474: a.from_parent_table_name,
2475: DECODE(a.from_parent_table_name,
2476: 'INL_SHIP_LINES',
2477: (SELECT MAX(sl.ship_line_id)
2478: FROM inl_ship_lines_all sl,
2479: inl_ship_lines_all sl0
2480: WHERE sl0.ship_line_id = a.from_parent_table_id
2481: AND sl.ship_header_id = sl0.ship_header_id
2482: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 2479: inl_ship_lines_all sl0

2475: DECODE(a.from_parent_table_name,
2476: 'INL_SHIP_LINES',
2477: (SELECT MAX(sl.ship_line_id)
2478: FROM inl_ship_lines_all sl,
2479: inl_ship_lines_all sl0
2480: WHERE sl0.ship_line_id = a.from_parent_table_id
2481: AND sl.ship_header_id = sl0.ship_header_id
2482: AND sl.ship_line_group_id = sl0.ship_line_group_id
2483: AND sl.ship_line_num = sl0.ship_line_num

Line 2515: FROM inl_ship_lines_all sl,

2511: a.to_parent_table_name,
2512: DECODE(a.to_parent_table_name,
2513: 'INL_SHIP_LINES',
2514: (SELECT MAX(sl.ship_line_id)
2515: FROM inl_ship_lines_all sl,
2516: inl_ship_lines_all sl0
2517: WHERE sl0.ship_line_id = a.to_parent_table_id
2518: AND sl.ship_header_id = sl0.ship_header_id
2519: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 2516: inl_ship_lines_all sl0

2512: DECODE(a.to_parent_table_name,
2513: 'INL_SHIP_LINES',
2514: (SELECT MAX(sl.ship_line_id)
2515: FROM inl_ship_lines_all sl,
2516: inl_ship_lines_all sl0
2517: WHERE sl0.ship_line_id = a.to_parent_table_id
2518: AND sl.ship_header_id = sl0.ship_header_id
2519: AND sl.ship_line_group_id = sl0.ship_line_group_id
2520: AND sl.ship_line_num = sl0.ship_line_num

Line 2932: FROM inl_ship_lines_all a

2928: WHERE a2.ship_header_id = updalloc_List(iUpdAlloc).ship_header_id
2929: AND NVL(a2.association_id,0) = NVL(updalloc_List(iUpdAlloc).association_id,0)
2930: AND (a2.ship_line_id = updalloc_List(iUpdAlloc).ship_line_id
2931: OR a2.ship_line_id = (SELECT a.parent_ship_line_id
2932: FROM inl_ship_lines_all a
2933: WHERE a.ship_line_id = updalloc_List(iUpdAlloc).ship_line_id))
2934:
2935: AND a2.adjustment_num = 0
2936: AND NOT EXISTS (SELECT 'X' FROM inl_allocations a1

Line 3030: FROM inl_ship_lines_all sl,

3026: a.from_parent_table_name,
3027: DECODE(a.from_parent_table_name,
3028: 'INL_SHIP_LINES',
3029: (SELECT MAX(sl.ship_line_id)
3030: FROM inl_ship_lines_all sl,
3031: inl_ship_lines_all sl0
3032: WHERE sl0.ship_line_id = a.from_parent_table_id
3033: AND sl.ship_header_id = sl0.ship_header_id
3034: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 3031: inl_ship_lines_all sl0

3027: DECODE(a.from_parent_table_name,
3028: 'INL_SHIP_LINES',
3029: (SELECT MAX(sl.ship_line_id)
3030: FROM inl_ship_lines_all sl,
3031: inl_ship_lines_all sl0
3032: WHERE sl0.ship_line_id = a.from_parent_table_id
3033: AND sl.ship_header_id = sl0.ship_header_id
3034: AND sl.ship_line_group_id = sl0.ship_line_group_id
3035: AND sl.ship_line_num = sl0.ship_line_num

Line 3068: FROM inl_ship_lines_all sl,

3064: a.to_parent_table_name,
3065: DECODE(a.to_parent_table_name,
3066: 'INL_SHIP_LINES',
3067: (SELECT MAX(sl.ship_line_id)
3068: FROM inl_ship_lines_all sl,
3069: inl_ship_lines_all sl0
3070: WHERE sl0.ship_line_id = a.to_parent_table_id
3071: AND sl.ship_header_id = sl0.ship_header_id
3072: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 3069: inl_ship_lines_all sl0

3065: DECODE(a.to_parent_table_name,
3066: 'INL_SHIP_LINES',
3067: (SELECT MAX(sl.ship_line_id)
3068: FROM inl_ship_lines_all sl,
3069: inl_ship_lines_all sl0
3070: WHERE sl0.ship_line_id = a.to_parent_table_id
3071: AND sl.ship_header_id = sl0.ship_header_id
3072: AND sl.ship_line_group_id = sl0.ship_line_group_id
3073: AND sl.ship_line_num = sl0.ship_line_num

Line 3099: FROM inl_ship_lines_all sl,

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,
3100: inl_ship_lines_all sl0
3101: WHERE sl0.ship_line_id = a.from_parent_table_id
3102: AND sl.ship_header_id = sl0.ship_header_id
3103: AND sl.ship_line_group_id = sl0.ship_line_group_id

Line 3100: inl_ship_lines_all sl0

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,
3100: inl_ship_lines_all sl0
3101: WHERE sl0.ship_line_id = a.from_parent_table_id
3102: AND sl.ship_header_id = sl0.ship_header_id
3103: AND sl.ship_line_group_id = sl0.ship_line_group_id
3104: AND sl.ship_line_num = sl0.ship_line_num

Line 3148: FROM inl_ship_lines_all ol

3144: ship_line_id,
3145: primary_qty,
3146: -- bug 7660824
3147: DECODE(landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0) fc_primary_unit_price
3148: FROM inl_ship_lines_all ol
3149: WHERE ol.ship_header_id = p_ship_header_id
3150: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
3151: FROM inl_ship_lines_all sl
3152: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084

Line 3151: FROM inl_ship_lines_all sl

3147: DECODE(landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0) fc_primary_unit_price
3148: FROM inl_ship_lines_all ol
3149: WHERE ol.ship_header_id = p_ship_header_id
3150: AND ol.ship_line_id = (SELECT MAX(sl.ship_line_id)
3151: FROM inl_ship_lines_all sl
3152: WHERE sl.ship_header_id = ol.ship_header_id --Bug#9660084
3153: AND sl.ship_line_group_id = ol.ship_line_group_id --Bug#9660084
3154: AND sl.ship_line_num = ol.ship_line_num --Bug#9660084
3155: --- SCM-051

Line 3449: FROM inl_ship_lines_all sl

3445: /* --Bug#14081759 BEG
3446: SELECT NVL(MIN(x.adjustment_num), l_last_adjustment_num) --Bug#10221931
3447: INTO l_current_adjustment_num
3448: FROM (SELECT sl.adjustment_num adjustment_num
3449: FROM inl_ship_lines_all sl
3450: WHERE sl.ship_header_id = p_ship_header_id
3451: UNION ALL
3452: SELECT sl.adjustment_num adjustment_num
3453: FROM inl_ship_lines_all sl

Line 3453: FROM inl_ship_lines_all sl

3449: FROM inl_ship_lines_all sl
3450: WHERE sl.ship_header_id = p_ship_header_id
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'

Line 3484: FROM inl_ship_lines_all sl

3480: SELECT
3481: MIN
3482: (LEAST
3483: (( SELECT NVL(MIN(ABS(sl.adjustment_num)),l_last_adjustment_num)
3484: FROM inl_ship_lines_all sl
3485: WHERE sl.ship_header_id = p_ship_header_id
3486: AND ABS(sl.adjustment_num) >= ABS(l_i_adj)
3487: AND ABS(sl.adjustment_num) <= ABS(l_last_adjustment_num)
3488: ),

Line 3716: FROM inl_ship_lines_all ol

3712: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_SHIP_HEADERS' THEN
3713: ----BUG#971 9618 SELECT SUM(NVL(ol.primary_qty,0)*NVL( ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0))
3714: SELECT SUM(NVL(ol.primary_qty,0)*NVL(DECODE(ol.landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0),0)) --BUG#9719618
3715: INTO l_from_amount
3716: FROM inl_ship_lines_all ol
3717: WHERE ol.ship_header_id = assoc_List(iAssoc).from_parent_table_id;
3718: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_SHIP_LINES' THEN
3719: ---- bug 7660824
3720: SELECT SUM(NVL(ol.primary_qty,0)*NVL(DECODE(ol.landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0),0))

Line 3722: FROM inl_ship_lines_all ol

3718: ELSIF assoc_List(iAssoc).from_parent_table_name = 'INL_SHIP_LINES' THEN
3719: ---- bug 7660824
3720: SELECT SUM(NVL(ol.primary_qty,0)*NVL(DECODE(ol.landed_cost_flag,'Y',ol.primary_unit_price * NVL(ol.currency_conversion_rate,1),0),0))
3721: INTO l_from_amount
3722: FROM inl_ship_lines_all ol
3723: WHERE ol.ship_line_id = assoc_List(iAssoc).from_parent_table_id;
3724: END IF;
3725:
3726: l_debug_info := 'l_from_amount';