APPS.BOMPCMBM dependencies on BOM_OPERATION_SEQUENCES

Line 3334: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom

3330: WHERE bco.component_sequence_id = bic.component_sequence_id
3331: AND bic.component_sequence_id = p_component_sequence_id
3332: AND EXISTS(
3333: SELECT operation_seq_num, bos.routing_sequence_id
3334: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom
3335: WHERE bos.routing_sequence_id = bor.common_routing_sequence_id
3336: AND bos.operation_seq_num = bco.operation_seq_num
3337: AND bor.assembly_item_id = bom.assembly_item_id
3338: AND bor.organization_id = bom.ORGANIZATION_id

Line 3789: From BOM_OPERATION_SEQUENCES

3785:
3786: /* Cursor get_primary_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3787: IS
3788: Select OPERATION_SEQ_NUM
3789: From BOM_OPERATION_SEQUENCES
3790: Where Routing_Sequence_Id = (Select common_routing_sequence_id
3791: from bom_operational_routings
3792: where assembly_item_id = p_assy_item_id
3793: and organization_id = p_org_id

Line 3809: From BOM_OPERATION_SEQUENCES

3805: */
3806: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3807: IS
3808: Select OPERATION_SEQ_NUM
3809: From BOM_OPERATION_SEQUENCES
3810: Where Routing_Sequence_Id = (Select common_routing_sequence_id
3811: from bom_operational_routings
3812: where assembly_item_id = p_assy_item_id
3813: and organization_id = p_org_id

Line 4185: From BOM_OPERATION_SEQUENCES

4181:
4182: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
4183: IS
4184: Select OPERATION_SEQ_NUM
4185: From BOM_OPERATION_SEQUENCES
4186: Where Routing_Sequence_Id = (Select common_routing_sequence_id
4187: from bom_operational_routings
4188: where assembly_item_id = p_assy_item_id
4189: and organization_id = p_org_id