APPS.BOM_VALIDATE_RTG_HEADER dependencies on MTL_SYSTEM_ITEMS

Line 212: FROM mtl_system_items

208: , NVL(eam_item_type, 0 )
209: INTO l_bom_item_type
210: , l_assembly_type
211: , l_eam_item_type
212: FROM mtl_system_items
213: WHERE inventory_item_id = p_assembly_item_id
214: AND organization_id = p_organization_id;
215:
216: /* Commented for bug 3277905

Line 960: FROM MTL_SYSTEM_ITEMS

956: IS
957: SELECT DECODE(restrict_subinventories_code, 1, 'Y', 'N')
958: restrict_code
959: , inventory_asset_flag
960: FROM MTL_SYSTEM_ITEMS
961: WHERE inventory_item_id = p_assembly_item_id
962: AND organization_id = p_organization_id ;
963:
964:

Line 1021: FROM mtl_system_items

1017:
1018: -- Get Value of Item Locator
1019: SELECT location_control_code
1020: INTO l_item_locator_control
1021: FROM mtl_system_items
1022: WHERE organization_id = p_organization_id
1023: AND inventory_item_id = p_assembly_item_id ;
1024:
1025: -- Get if locator is restricted or unrestricted

Line 1028: FROM mtl_system_items

1024:
1025: -- Get if locator is restricted or unrestricted
1026: SELECT RESTRICT_LOCATORS_CODE
1027: INTO l_item_loc_restricted
1028: FROM mtl_system_items
1029: WHERE organization_id = p_organization_id
1030: AND inventory_item_id = p_assembly_item_id ;
1031:
1032:

Line 1244: l_ser_num_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE;

1240: l_bom_item_type NUMBER;
1241: l_pto_flag VARCHAR2(1);
1242: l_eng_item_flag VARCHAR2(1);
1243: l_bom_enabled_flag VARCHAR2(1);
1244: l_ser_num_control_code MTL_SYSTEM_ITEMS.SERIAL_NUMBER_CONTROL_CODE%TYPE;
1245:
1246: l_sub_inv_exists BOOLEAN := FALSE;
1247: l_allow_expense_to_asset VARCHAR2(10);
1248: l_rest_subinv_code VARCHAR2(1);

Line 1265: FROM MTL_SYSTEM_ITEMS

1261: , pick_components_flag
1262: , bom_enabled_flag
1263: , eng_item_flag
1264: , serial_number_control_code
1265: FROM MTL_SYSTEM_ITEMS
1266: WHERE organization_id = p_org_id
1267: AND inventory_item_id = p_item_id;
1268:
1269: -- cursor for checking common assembly chain

Line 2617: from mtl_system_items m

2613: IS
2614:
2615: CURSOR lot_check is
2616: select lot_control_code
2617: from mtl_system_items m
2618: where m.organization_id = p_organization_id
2619: and m.inventory_item_id = p_assembly_item_id;
2620:
2621: BEGIN

Line 2652: l_ser_num_control_code MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE%TYPE;

2648: )
2649: IS
2650:
2651: l_cfm_routing_flag BOM_OPERATIONAL_ROUTINGS.CFM_ROUTING_FLAG%TYPE;
2652: l_ser_num_control_code MTL_SYSTEM_ITEMS_B.SERIAL_NUMBER_CONTROL_CODE%TYPE;
2653: l_ser_start_op_seq BOM_OPERATIONAL_ROUTINGS.SERIALIZATION_START_OP%TYPE;
2654: l_nw_opern_count NUMBER;
2655: l_retval INTEGER;
2656: l_start_op_seq_id NUMBER;

Line 2680: FROM BOM_OPERATIONAL_ROUTINGS bor, MTL_SYSTEM_ITEMS_B msib

2676: msib.SERIAL_NUMBER_CONTROL_CODE
2677: INTO l_cfm_routing_flag,
2678: l_ser_start_op_seq,
2679: l_ser_num_control_code
2680: FROM BOM_OPERATIONAL_ROUTINGS bor, MTL_SYSTEM_ITEMS_B msib
2681: WHERE
2682: bor.ASSEMBLY_ITEM_ID = msib.INVENTORY_ITEM_ID
2683: AND bor.ORGANIZATION_ID = msib.ORGANIZATION_ID
2684: AND bor.ROUTING_SEQUENCE_ID = p_routing_sequence_id;