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 312: l_inventory_item_id mtl_system_items.inventory_item_id%type;

308: -- Procuring Configuration Project
309: -- Added on 08/29/01
310:
311: l_sourcing_rule_exists varchar2(1);
312: l_inventory_item_id mtl_system_items.inventory_item_id%type;
313: l_ship_from_org_id mtl_system_items.organization_id%type;
314: l_source_type Number;
315: l_sourcing_org Number;
316: l_transit_lead_time Number;

Line 313: l_ship_from_org_id mtl_system_items.organization_id%type;

309: -- Added on 08/29/01
310:
311: l_sourcing_rule_exists varchar2(1);
312: l_inventory_item_id mtl_system_items.inventory_item_id%type;
313: l_ship_from_org_id mtl_system_items.organization_id%type;
314: l_source_type Number;
315: l_sourcing_org Number;
316: l_transit_lead_time Number;
317: l_exp_error_code Number;

Line 407: ' mtl_system_items MSI ';

403: 'from '||
404: ' oe_order_lines_all OEL, '||
405: ' wf_item_activity_statuses WAS, '||
406: ' wf_process_activities WPA, '||
407: ' mtl_system_items MSI ';
408: else
409: -- Use a different order sequence of tables
410:
411:

Line 428: ' mtl_system_items MSI ';

424: 'from '||
425: ' wf_process_activities WPA, '||
426: ' wf_item_activity_statuses WAS, '||
427: ' oe_order_lines_all OEL, '||
428: ' mtl_system_items MSI ';
429: end if;
430:
431:
432: -- rkaza. 07/29/2005. bug 4438574. Item type code will be standard for

Line 1531: mtl_system_items msi -- bugfix 1661094:

1527: mtl_sales_orders mso,
1528: oe_order_headers_all oeh,
1529: --oe_order_types_v oet
1530: oe_transaction_types_tl oet,
1531: mtl_system_items msi -- bugfix 1661094:
1532: where wei.group_id = p_wip_seq
1533: and wei.source_line_id = oel.line_id
1534: and oeh.header_id = oel.header_id
1535: and oet.transaction_type_id = oeh.order_type_id

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

1899: null)),0)
1900: from mtl_reservations mr,
1901: oe_order_headers_all oeh,
1902: oe_order_lines_all oel,
1903: mtl_system_items msi --bugfix 2074290: added msi
1904: where oel.line_id = pLineId
1905: and oel.header_id = oeh.header_id
1906: and mr.demand_source_line_id = oel.line_id
1907: and mr.organization_id = oel.ship_from_org_id

Line 2048: mtl_system_items msi

2044: 'Y', nvl(sum(wdd.requested_quantity), 0) )
2045: into l_quantity
2046: from WSH_DELIVERY_DETAILS_OB_GRP_V wdd,
2047: oe_order_lines_all oel,
2048: mtl_system_items msi
2049: where oel.line_id = pLineId
2050: and oel.inventory_item_id = msi.inventory_item_id
2051: and oel.ship_from_org_id = msi.organization_id
2052: and wdd.source_line_id(+) = oel.line_id