DBA Data[Home] [Help]

APPS.CTO_MSUTIL_PUB dependencies on MTL_SYSTEM_ITEMS

Line 1607: from MTL_SYSTEM_ITEMS

1603:
1604:
1605: select planning_make_buy_code
1606: into l_make_buy_code
1607: from MTL_SYSTEM_ITEMS
1608: where inventory_item_id = pModelItemId
1609: and organization_id = pRcvOrgId;
1610:
1611:

Line 1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;

1951:
1952: v_t_sourcing_info SOURCING_INFO;
1953: v_buy_traversed boolean := false ;
1954: v_source_type mrp_sources_v.source_type%type ;
1955: l_make_buy_code mtl_system_items.planning_make_buy_code%type ;
1956:
1957: l_curr_src_org mrp_sources_v.source_organization_id%type ;
1958: l_source_type mrp_sources_v.source_type%type ;
1959: l_curr_assg_type mrp_sources_v.assignment_type%type ;

Line 2469: FROM MTL_SYSTEM_ITEMS

2465: BEGIN
2466:
2467: SELECT planning_make_buy_code
2468: INTO l_make_buy_code
2469: FROM MTL_SYSTEM_ITEMS
2470: WHERE inventory_item_id = p_model_item_id
2471: AND organization_id = p_organization_id ;
2472:
2473: EXCEPTION

Line 2724: FROM MTL_SYSTEM_ITEMS

2720:
2721: IF gMrpAssignmentSet is NULL Then
2722: SELECT planning_make_buy_code
2723: INTO l_make_buy_code
2724: FROM MTL_SYSTEM_ITEMS
2725: WHERE inventory_item_id = p_inventory_item_id
2726: AND organization_id = p_organization_id;
2727:
2728: IF l_make_buy_code = 2 THEN

Line 2835: FROM MTL_SYSTEM_ITEMS

2831: --- so that the calling application will knwo this as buy model
2832:
2833: SELECT planning_make_buy_code
2834: INTO l_make_buy_code
2835: FROM MTL_SYSTEM_ITEMS
2836: WHERE inventory_item_id = p_inventory_item_id
2837: AND organization_id = p_organization_id;
2838:
2839: IF l_make_buy_code = 2 THEN

Line 4187: from mtl_system_items msi

4183: gLoginId, -- last_update_login
4184: null, -- program_application_id,??
4185: null, -- program_id,??
4186: sysdate -- program_update_date
4187: from mtl_system_items msi
4188: where msi.inventory_item_id = p_model_item_id
4189: and NOT EXISTS
4190: (select NULL
4191: from bom_cto_src_orgs_b

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

4255: gLoginId, -- last_update_login
4256: null, -- program_application_id,??
4257: null, -- program_id,??
4258: sysdate -- program_update_date
4259: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4260: where msi.inventory_item_id = p_model_item_id
4261: and msi.inventory_item_id = bom.assembly_item_id(+)
4262: and msi.organization_id = bom.organization_id(+)
4263: and bom.alternate_bom_designator is null

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

4335: gLoginId, -- last_update_login
4336: null, -- program_application_id,??
4337: null, -- program_id,??
4338: sysdate -- program_update_date
4339: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4340: where msi.inventory_item_id = p_model_item_id
4341: and msi.inventory_item_id = bom.assembly_item_id(+)
4342: and msi.organization_id = bom.organization_id(+)
4343: and bom.alternate_bom_designator is null

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

4484: gLoginId, -- last_update_login
4485: null, -- program_application_id,??
4486: null, -- program_id,??
4487: sysdate -- program_update_date
4488: from mtl_system_items msi, bom_bill_of_materials bom, bom_parameters bp
4489: where msi.inventory_item_id = p_model_item_id
4490: and msi.inventory_item_id = bom.assembly_item_id(+)
4491: and msi.organization_id = bom.organization_id(+)
4492: and bom.alternate_bom_designator is null

Line 4657: from mtl_system_items

4653: lstmt_num := 99;
4654:
4655: select organization_id
4656: BULK COLLECT into xOrgLst
4657: from mtl_system_items
4658: where inventory_item_id = xModelItemId
4659: and organization_id not in (
4660: select organization_id
4661: from bom_cto_src_orgs