APPS.BOMPCMBM dependencies on BOM_OPERATIONAL_ROUTINGS

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 3774: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3770:
3771: /* Cursor check_src_routing_exists(p_src_bill_sequence_id NUMBER)
3772: IS
3773: Select 'Routing Exists'
3774: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3775: Where bom.assembly_item_id = bor.assembly_item_id
3776: And bom.organization_id = bor.organizatin_id
3777: And nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3778: And bom.bill_sequence_id = p_src_bill_sequence_id*/

Line 3791: from bom_operational_routings

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
3794: and alternate_routing_designator is null
3795: and not exists

Line 3797: from bom_operational_routings

3793: and organization_id = p_org_id
3794: and alternate_routing_designator is null
3795: and not exists
3796: (select 1
3797: from bom_operational_routings
3798: where assembly_item_id = p_assy_item_id
3799: and organization_id = p_org_id
3800: and alternate_routing_designator = p_alt_desg
3801: )

Line 3811: from bom_operational_routings

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
3814: and nvl(alternate_routing_designator, 'XXX') = nvl(p_alt_desg, 'XXX'))
3815:

Line 3830: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3826: --Check if Routing exists for the source bom
3827: BEGIN
3828: Select 'Routing Exists'
3829: INTO l_rtg_exist
3830: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3831: Where bom.assembly_item_id = bor.assembly_item_id
3832: And bom.organization_id = bor.organization_id
3833: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3834: OR bor.alternate_routing_designator IS NULL)

Line 3846: FROM BOM_OPERATIONAL_ROUTINGS

3842: THEN
3843: BEGIN
3844: SELECT 1
3845: INTO l_alt_rtg_exists
3846: FROM BOM_OPERATIONAL_ROUTINGS
3847: WHERE assembly_item_id = p_assembly_item_id
3848: AND organization_id = p_organization_id
3849: AND alternate_routing_designator = p_alt_desg;
3850: EXCEPTION

Line 4187: from bom_operational_routings

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
4190: and nvl(alternate_routing_designator, 'XXX') = nvl(p_alt_desg, 'XXX'));
4191:

Line 4206: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

4202:
4203: BEGIN
4204: Select 'Routing Exists'
4205: INTO l_rtg_exist
4206: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
4207: Where bom.assembly_item_id = bor.assembly_item_id
4208: And bom.organization_id = bor.organization_id
4209: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
4210: OR bor.alternate_routing_designator IS NULL