APPS.BOMPCMBM dependencies on BOM_OPERATIONAL_ROUTINGS

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

3478:
3479: /* Cursor check_src_routing_exists(p_src_bill_sequence_id NUMBER)
3480: IS
3481: Select 'Routing Exists'
3482: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3483: Where bom.assembly_item_id = bor.assembly_item_id
3484: And bom.organization_id = bor.organizatin_id
3485: And nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3486: And bom.bill_sequence_id = p_src_bill_sequence_id*/

Line 3499: from bom_operational_routings

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
3502: and alternate_routing_designator is null
3503: and not exists

Line 3505: from bom_operational_routings

3501: and organization_id = p_org_id
3502: and alternate_routing_designator is null
3503: and not exists
3504: (select 1
3505: from bom_operational_routings
3506: where assembly_item_id = p_assy_item_id
3507: and organization_id = p_org_id
3508: and alternate_routing_designator = p_alt_desg
3509: )

Line 3519: from bom_operational_routings

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

Line 3538: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3534: --Check if Routing exists for the source bom
3535: BEGIN
3536: Select 'Routing Exists'
3537: INTO l_rtg_exist
3538: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3539: Where bom.assembly_item_id = bor.assembly_item_id
3540: And bom.organization_id = bor.organization_id
3541: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3542: OR bor.alternate_routing_designator IS NULL)

Line 3554: FROM BOM_OPERATIONAL_ROUTINGS

3550: THEN
3551: BEGIN
3552: SELECT 1
3553: INTO l_alt_rtg_exists
3554: FROM BOM_OPERATIONAL_ROUTINGS
3555: WHERE assembly_item_id = p_assembly_item_id
3556: AND organization_id = p_organization_id
3557: AND alternate_routing_designator = p_alt_desg;
3558: EXCEPTION

Line 3866: from bom_operational_routings

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

Line 3885: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom

3881:
3882: BEGIN
3883: Select 'Routing Exists'
3884: INTO l_rtg_exist
3885: from BOM_OPERATIONAL_ROUTINGS bor, BOM_STRUCTURES_B bom
3886: Where bom.assembly_item_id = bor.assembly_item_id
3887: And bom.organization_id = bor.organization_id
3888: And (nvl(bor.alternate_routing_designator, 'XXX') = nvl(bom.alternate_bom_designator, 'XXX')
3889: OR bor.alternate_routing_designator IS NULL