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_MSUTIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1589: from MTL_SYSTEM_ITEMS

1585: -- On 12/21/01. The where condition organization_id is modified
1586:
1587: select planning_make_buy_code
1588: into l_make_buy_code
1589: from MTL_SYSTEM_ITEMS
1590: where inventory_item_id = pModelItemId
1591: and organization_id = pRcvOrgId;
1592:
1593: IF PG_DEBUG <> 0 THEN

Line 1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;

1901:
1902: v_t_sourcing_info SOURCING_INFO;
1903: v_buy_traversed boolean := false ;
1904: v_source_type mrp_sources_v.source_type%type ;
1905: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1906:
1907: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1908: l_source_type mrp_sources_v.source_type%type ;
1909: l_curr_assg_type mrp_sources_v.assignment_type%type ;

Line 2456: FROM MTL_SYSTEM_ITEMS

2452: BEGIN
2453:
2454: SELECT planning_make_buy_code
2455: INTO l_make_buy_code
2456: FROM MTL_SYSTEM_ITEMS
2457: WHERE inventory_item_id = p_model_item_id
2458: AND organization_id = p_organization_id ;
2459:
2460: EXCEPTION

Line 2714: FROM MTL_SYSTEM_ITEMS

2710:
2711: IF gMrpAssignmentSet is NULL Then
2712: SELECT planning_make_buy_code
2713: INTO l_make_buy_code
2714: FROM MTL_SYSTEM_ITEMS
2715: WHERE inventory_item_id = p_inventory_item_id
2716: AND organization_id = p_organization_id;
2717:
2718: IF l_make_buy_code = 2 THEN

Line 2825: FROM MTL_SYSTEM_ITEMS

2821: --- so that the calling application will knwo this as buy model
2822:
2823: SELECT planning_make_buy_code
2824: INTO l_make_buy_code
2825: FROM MTL_SYSTEM_ITEMS
2826: WHERE inventory_item_id = p_inventory_item_id
2827: AND organization_id = p_organization_id;
2828:
2829: IF l_make_buy_code = 2 THEN

Line 4704: from mtl_system_items msi

4700: gLoginId, -- last_update_login
4701: null, -- program_application_id,??
4702: null, -- program_id,??
4703: sysdate -- program_update_date
4704: from mtl_system_items msi
4705: where msi.inventory_item_id = p_model_item_id
4706: and NOT EXISTS
4707: (select NULL
4708: from bom_cto_src_orgs_b

Line 4776: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

4772: gLoginId, -- last_update_login
4773: null, -- program_application_id,??
4774: null, -- program_id,??
4775: sysdate -- program_update_date
4776: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4777: where msi.inventory_item_id = p_model_item_id
4778: and msi.inventory_item_id = bom.assembly_item_id(+)
4779: and msi.organization_id = bom.organization_id(+)
4780: and bom.alternate_bom_designator is null

Line 4856: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

4852: gLoginId, -- last_update_login
4853: null, -- program_application_id,??
4854: null, -- program_id,??
4855: sysdate -- program_update_date
4856: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4857: where msi.inventory_item_id = p_model_item_id
4858: and msi.inventory_item_id = bom.assembly_item_id(+)
4859: and msi.organization_id = bom.organization_id(+)
4860: and bom.alternate_bom_designator is null

Line 5013: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp

5009: gLoginId, -- last_update_login
5010: null, -- program_application_id,??
5011: null, -- program_id,??
5012: sysdate -- program_update_date
5013: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
5014: where msi.inventory_item_id = p_model_item_id
5015: and msi.inventory_item_id = bom.assembly_item_id(+)
5016: and msi.organization_id = bom.organization_id(+)
5017: and bom.alternate_bom_designator is null

Line 5187: from mtl_system_items

5183: lstmt_num := 99;
5184:
5185: select organization_id
5186: BULK COLLECT into xOrgLst
5187: from mtl_system_items
5188: where inventory_item_id = xModelItemId
5189: and organization_id not in (
5190: select organization_id
5191: from bom_cto_src_orgs

Line 5966: from mtl_system_items_b

5962: l_org number;
5963:
5964: CURSOR config_orgs(pConfigId number) IS
5965: select organization_id
5966: from mtl_system_items_b
5967: where inventory_item_id = pConfigId;
5968:
5969: BEGIN
5970: IF PG_DEBUG <> 0 THEN