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.CTO_WIP_WRAPPER dependencies on MTL_SYSTEM_ITEMS

Line 304: l_inventory_item_id mtl_system_items.inventory_item_id%type;

300: -- Procuring Configuration Project
301: -- Added on 08/29/01
302:
303: l_sourcing_rule_exists varchar2(1);
304: l_inventory_item_id mtl_system_items.inventory_item_id%type;
305: l_ship_from_org_id mtl_system_items.organization_id%type;
306: l_source_type Number;
307: l_sourcing_org Number;
308: l_transit_lead_time Number;

Line 305: l_ship_from_org_id mtl_system_items.organization_id%type;

301: -- Added on 08/29/01
302:
303: l_sourcing_rule_exists varchar2(1);
304: l_inventory_item_id mtl_system_items.inventory_item_id%type;
305: l_ship_from_org_id mtl_system_items.organization_id%type;
306: l_source_type Number;
307: l_sourcing_org Number;
308: l_transit_lead_time Number;
309: l_exp_error_code Number;

Line 399: ' mtl_system_items MSI ';

395: 'from '||
396: ' oe_order_lines_all OEL, '||
397: ' wf_item_activity_statuses WAS, '||
398: ' wf_process_activities WPA, '||
399: ' mtl_system_items MSI ';
400: else
401: -- Use a different order sequence of tables
402:
403:

Line 420: ' mtl_system_items MSI ';

416: 'from '||
417: ' wf_process_activities WPA, '||
418: ' wf_item_activity_statuses WAS, '||
419: ' oe_order_lines_all OEL, '||
420: ' mtl_system_items MSI ';
421: end if;
422:
423:
424: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for

Line 1387: mtl_system_items msi -- bugfix 1661094:

1383: mtl_sales_orders mso,
1384: oe_order_headers_all oeh,
1385: --oe_order_types_v oet
1386: oe_transaction_types_tl oet,
1387: mtl_system_items msi -- bugfix 1661094:
1388: where wei.group_id = p_wip_seq
1389: and wei.source_line_id = oel.line_id
1390: and oeh.header_id = oel.header_id
1391: and oet.transaction_type_id = oeh.order_type_id

Line 1757: mtl_system_items msi --bugfix 2074290: added msi

1753: null)),0)
1754: from mtl_reservations mr,
1755: oe_order_headers_all oeh,
1756: oe_order_lines_all oel,
1757: mtl_system_items msi --bugfix 2074290: added msi
1758: where oel.line_id = pLineId
1759: and oel.header_id = oeh.header_id
1760: and mr.demand_source_line_id = oel.line_id
1761: and mr.organization_id = oel.ship_from_org_id

Line 1900: mtl_system_items msi

1896: 'Y', nvl(sum(wdd.requested_quantity), 0) )
1897: into l_quantity
1898: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
1899: oe_order_lines_all oel,
1900: mtl_system_items msi
1901: where oel.line_id = pLineId
1902: and oel.inventory_item_id = msi.inventory_item_id
1903: and oel.ship_from_org_id = msi.organization_id
1904: and wdd.source_line_id(+) = oel.line_id