APPS.BOMPCMBM dependencies on BOM_OPERATION_SEQUENCES

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

3038: WHERE bco.component_sequence_id = bic.component_sequence_id
3039: AND bic.component_sequence_id = p_component_sequence_id
3040: AND EXISTS(
3041: SELECT operation_seq_num, bos.routing_sequence_id
3042: FROM bom_operational_routings bor, bom_operation_sequences bos, BOM_STRUCTURES_B bom
3043: WHERE bos.routing_sequence_id = bor.common_routing_sequence_id
3044: AND bos.operation_seq_num = bco.operation_seq_num
3045: AND bor.assembly_item_id = bom.assembly_item_id
3046: AND bor.organization_id = bom.ORGANIZATION_id

Line 3497: From BOM_OPERATION_SEQUENCES

3493:
3494: /* Cursor get_primary_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3495: IS
3496: Select OPERATION_SEQ_NUM
3497: From BOM_OPERATION_SEQUENCES
3498: Where Routing_Sequence_Id = (Select common_routing_sequence_id
3499: from bom_operational_routings
3500: where assembly_item_id = p_assy_item_id
3501: and organization_id = p_org_id

Line 3517: From BOM_OPERATION_SEQUENCES

3513: */
3514: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3515: IS
3516: Select OPERATION_SEQ_NUM
3517: From BOM_OPERATION_SEQUENCES
3518: Where Routing_Sequence_Id = (Select common_routing_sequence_id
3519: from bom_operational_routings
3520: where assembly_item_id = p_assy_item_id
3521: and organization_id = p_org_id

Line 3864: From BOM_OPERATION_SEQUENCES

3860:
3861: Cursor get_rtg_opns(p_assy_item_id NUMBER, p_org_id NUMBER, p_alt_desg VARCHAR2)
3862: IS
3863: Select OPERATION_SEQ_NUM
3864: From BOM_OPERATION_SEQUENCES
3865: Where Routing_Sequence_Id = (Select common_routing_sequence_id
3866: from bom_operational_routings
3867: where assembly_item_id = p_assy_item_id
3868: and organization_id = p_org_id