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_ADJ_SHIP_LINES_V

Line 716: FROM inl_adj_ship_lines_v ol

712: NVL(ol.primary_qty,0),
713: ol.primary_uom_code,
714: p_allocation_uom_code))) + l_total_amt
715: INTO l_total_amt
716: FROM inl_adj_ship_lines_v ol
717: WHERE ol.ship_header_id = rec_assoc.to_parent_table_id;
718:
719: ELSIF rec_assoc.to_parent_table_name = 'INL_SHIP_LINE_GROUPS' THEN
720: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.fc_primary_unit_price,0),0),

Line 728: FROM inl_adj_ship_lines_v ol

724: -- Bug #7674125
725: ol.primary_uom_code,
726: p_allocation_uom_code))) + l_total_amt
727: INTO l_total_amt
728: FROM inl_adj_ship_lines_v ol
729: WHERE ol.ship_line_group_id = rec_assoc.to_parent_table_id;
730:
731: ELSIF rec_assoc.to_parent_table_name = 'INL_SHIP_LINES' THEN
732: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.fc_primary_unit_price,0),0),

Line 740: FROM inl_adj_ship_lines_v ol

736: -- Bug #7674125
737: ol.primary_uom_code,
738: p_allocation_uom_code))) + l_total_amt
739: INTO l_total_amt
740: FROM inl_adj_ship_lines_v ol
741: WHERE ol.ship_line_id = rec_assoc.to_parent_table_id;
742:
743: ELSIF rec_assoc.to_parent_table_name = 'INL_CHARGE_LINES' THEN
744: IF l_allocation_basis = 'VALUE' THEN

Line 800: FROM inl_adj_ship_lines_v ol

796: NVL(ol.primary_qty,0),
797: ol.primary_uom_code,
798: p_allocation_uom_code))) + l_total_amt
799: INTO l_total_amt
800: FROM inl_adj_ship_lines_v ol
801: WHERE ol.ship_header_id = DECODE(p_from_component_name,'INL_SHIP_HEADERS',p_from_component_id,ol.ship_header_id)
802: --- bug 7654293
803: AND ol.ship_line_group_id = DECODE(p_from_component_name,'INL_SHIP_LINE_GROUPS',p_from_component_id,ol.ship_line_group_id)
804: AND ol.ship_line_id = DECODE(p_from_component_name,'INL_SHIP_LINES',p_from_component_id,ol.ship_line_id)

Line 821: FROM inl_adj_ship_lines_v ol

817: NVL(ol.primary_qty,0),
818: ol.primary_uom_code,
819: p_allocation_uom_code)))
820: INTO l_to_component_amt
821: FROM inl_adj_ship_lines_v ol
822: WHERE ol.ship_header_id = p_to_component_id;
823:
824: ELSIF p_to_component_name = 'INL_SHIP_LINE_GROUPS' THEN
825: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.fc_primary_unit_price,0),0),

Line 832: FROM inl_adj_ship_lines_v ol

828: NVL(ol.primary_qty,0),
829: ol.primary_uom_code,
830: p_allocation_uom_code)))
831: INTO l_to_component_amt
832: FROM inl_adj_ship_lines_v ol
833: WHERE ol.ship_line_group_id = p_to_component_id;
834:
835: ELSIF p_to_component_name = 'INL_SHIP_LINES' THEN
836: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.fc_primary_unit_price,0),0),

Line 843: FROM inl_adj_ship_lines_v ol

839: NVL(ol.primary_qty,0),
840: ol.primary_uom_code,
841: p_allocation_uom_code)))
842: INTO l_to_component_amt
843: FROM inl_adj_ship_lines_v ol
844: WHERE ol.ship_line_id = p_to_component_id;
845: ELSIF p_to_component_name = 'INL_SHIP_DISTS' THEN
846: SELECT SUM(DECODE(l_allocation_basis,'VALUE',NVL(NVL(ol.primary_qty,0)*NVL(ol.fc_primary_unit_price,0),0),
847: Converted_Qty (l_inv_org_id,

Line 853: FROM inl_adj_ship_lines_v ol

849: NVL(ol.primary_qty,0),
850: ol.primary_uom_code,
851: p_allocation_uom_code)))
852: INTO l_to_component_amt
853: FROM inl_adj_ship_lines_v ol
854: WHERE ol.ship_line_id = p_to_component_id;
855: ELSIF p_to_component_name = 'INL_CHARGE_LINES' THEN
856: IF l_allocation_basis = 'VALUE' THEN
857: SELECT SUM(Converted_Amt (NVL(charge_amt,0),

Line 1100: FROM inl_adj_ship_lines_v ol

1096: /*
1097: BEGIN
1098: SELECT ol.landed_cost_flag
1099: INTO l_ship_line_lc_flag
1100: FROM inl_adj_ship_lines_v ol
1101: WHERE ol.ship_line_id = p_ship_line_id;
1102: EXCEPTION
1103: WHEN NO_DATA_FOUND THEN
1104: l_ship_line_lc_flag := 'N';

Line 1332: FROM inl_adj_ship_lines_v

1328: x_return_status OUT NOCOPY VARCHAR2)
1329: IS
1330: CURSOR dist IS
1331: SELECT ship_line_id
1332: FROM inl_adj_ship_lines_v
1333: WHERE ship_header_id = p_ship_header_id
1334: AND ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, ship_line_id)
1335: --- bug 7654293
1336: AND ship_line_group_id = DECODE(p_to_component_name, 'INL_SHIP_LINE_GROUPS', p_to_component_id, ship_line_group_id);

Line 1538: FROM inl_adj_ship_lines_v ol

1534: CURSOR component IS
1535: SELECT 1 SEQ_NUM,
1536: 'INL_SHIP_LINES' COMPONENT_NAME,
1537: ol.ship_line_id COMPONENT_ID
1538: FROM inl_adj_ship_lines_v ol
1539: WHERE ol.ship_header_id = p_ship_header_id
1540: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
1541: UNION
1542: SELECT 2 SEQ_NUM,

Line 1545: FROM inl_adj_ship_lines_v ol

1541: UNION
1542: SELECT 2 SEQ_NUM,
1543: 'INL_SHIP_HEADERS' COMPONENT_NAME,
1544: ol.ship_header_id COMPONENT_ID
1545: FROM inl_adj_ship_lines_v ol
1546: WHERE ol.ship_header_id = p_ship_header_id
1547: AND ol.ship_line_id = DECODE(p_to_component_name, 'INL_SHIP_LINES', p_to_component_id, -1)
1548: UNION
1549: SELECT 1 SEQ_NUM,

Line 1964: FROM inl_adj_ship_lines_v

1960: ship_line_id,
1961: primary_qty,
1962: -- bug 7660824
1963: DECODE(landed_cost_flag,'Y',fc_primary_unit_price,0) fc_primary_unit_price
1964: FROM inl_adj_ship_lines_v
1965: WHERE ship_header_id = p_ship_header_id
1966: AND p_calc_scope_code in (0,1)
1967: ORDER BY ship_line_id;
1968: rec_dist dist%ROWTYPE;

Line 2242: FROM inl_adj_ship_lines_v

2238: WHERE tax_line_id = rec_assoc.from_parent_table_id;
2239: ELSIF rec_assoc.from_parent_table_name = 'INL_SHIP_HEADERS' THEN
2240: SELECT SUM(NVL(primary_qty,0)*NVL(fc_primary_unit_price,0))
2241: INTO l_from_amount
2242: FROM inl_adj_ship_lines_v
2243: WHERE ship_header_id = rec_assoc.from_parent_table_id;
2244: ELSIF rec_assoc.from_parent_table_name = 'INL_SHIP_LINES' THEN
2245: -- bug 7660824
2246: SELECT SUM(NVL(primary_qty,0)*NVL(DECODE(landed_cost_flag,'Y',fc_primary_unit_price,0),0))

Line 2248: FROM inl_adj_ship_lines_v

2244: ELSIF rec_assoc.from_parent_table_name = 'INL_SHIP_LINES' THEN
2245: -- bug 7660824
2246: SELECT SUM(NVL(primary_qty,0)*NVL(DECODE(landed_cost_flag,'Y',fc_primary_unit_price,0),0))
2247: INTO l_from_amount
2248: FROM inl_adj_ship_lines_v
2249: WHERE ship_line_id = rec_assoc.from_parent_table_id;
2250: END IF;
2251:
2252: l_debug_info := 'l_from_amount';