DBA Data[Home] [Help]

APPS.BOM_VALIDATE_RTG_HEADER dependencies on MTL_SYSTEM_ITEMS_B

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;