APPS.WIP_BFLPROC_PRIV dependencies on BOM_BILL_OF_MATERIALS

Line 1056: from bom_bill_of_materials a

1052: -- FP Bug 4643335 : Rewrote the query by adding a subquery to improve performance.
1053: --FP Bug 6502612 : Added Check for Engineering BOMs .
1054: select a.organization_id, a.bill_sequence_id
1055: into l_cmnOrgID, l_cmnBillID
1056: from bom_bill_of_materials a
1057: where a.bill_sequence_id = (select b.common_bill_sequence_id
1058: from bom_bill_of_materials b
1059: where b.assembly_item_id = p_itemID
1060: and b.organization_id = p_orgID

Line 1058: from bom_bill_of_materials b

1054: select a.organization_id, a.bill_sequence_id
1055: into l_cmnOrgID, l_cmnBillID
1056: from bom_bill_of_materials a
1057: where a.bill_sequence_id = (select b.common_bill_sequence_id
1058: from bom_bill_of_materials b
1059: where b.assembly_item_id = p_itemID
1060: and b.organization_id = p_orgID
1061: and nvl(b.alternate_bom_designator, '@@@@@') = NVL(p_altBomDesig, '@@@@@')
1062: and (b.assembly_type = wip_constants.manufacturing_bill or --FP Bug 6502612

Line 1068: from bom_bill_of_materials a, bom_bill_of_materials b

1064:
1065: /******
1066: select a.organization_id, a.bill_sequence_id
1067: into l_cmnOrgID, l_cmnBillID
1068: from bom_bill_of_materials a, bom_bill_of_materials b
1069: where a.bill_sequence_id = b.common_bill_sequence_id
1070: and b.assembly_item_id = p_itemID
1071: and b.organization_id = p_orgID
1072: and nvl(b.alternate_bom_designator, '@@@@@') = nvl(p_altBomDesig, '@@@@@');

Line 1077: from bom_bill_of_materials a, bom_bill_of_materials b

1073: ******/
1074: else
1075: select a.organization_id, a.bill_sequence_id
1076: into l_cmnOrgID, l_cmnBillID
1077: from bom_bill_of_materials a, bom_bill_of_materials b
1078: where a.bill_sequence_id = b.common_bill_sequence_id
1079: and b.assembly_item_id = p_itemID
1080: and b.organization_id = p_orgID
1081: and ( nvl(b.alternate_bom_designator, '@@@@@') = nvl(p_altBomDesig , '@@@@@')

Line 1086: from bom_bill_of_materials c

1082: or
1083: ( b.alternate_bom_designator is null
1084: and
1085: not exists (select 'x'
1086: from bom_bill_of_materials c
1087: where c.assembly_item_id = p_itemID
1088: and c.organization_id = p_orgID
1089: and c.alternate_bom_designator = p_altBomDesig)
1090: )