APPS.BOM_COMPARISON_TEMP_PKG dependencies on BOM_BILL_OF_MATERIALS

Line 19: from BOM_BILL_OF_MATERIALS bom1

15: X_Assembly_Item_Id2 NUMBER,
16: X_Alternate1 VARCHAR2,
17: X_alternate2 VARCHAR2 ) IS
18: cursor c1 is select bom1.common_bill_sequence_id
19: from BOM_BILL_OF_MATERIALS bom1
20: where bom1.organization_id = X_Organization_Id1
21: and bom1.assembly_item_id = X_Assembly_Item_Id1
22: and nvl(bom1.alternate_bom_designator, 'NONE') =
23: nvl(X_Alternate1, 'NONE');

Line 25: from BOM_BILL_OF_MATERIALS bom2

21: and bom1.assembly_item_id = X_Assembly_Item_Id1
22: and nvl(bom1.alternate_bom_designator, 'NONE') =
23: nvl(X_Alternate1, 'NONE');
24: cursor c2 is select bom2.common_bill_sequence_id
25: from BOM_BILL_OF_MATERIALS bom2
26: where bom2.organization_id = X_Organization_Id2
27: and bom2.assembly_item_id = X_Assembly_Item_Id2
28: and nvl(bom2.alternate_bom_designator, 'NONE') =
29: nvl(X_Alternate2, 'NONE');

Line 48: select assembly_type from bom_bill_of_materials bom

44: FUNCTION Get_Bill_Type ( X_Organization_Id NUMBER,
45: X_Assembly_Item_Id NUMBER,
46: X_Alternate VARCHAR2 ) RETURN NUMBER IS
47: cursor c1 is
48: select assembly_type from bom_bill_of_materials bom
49: where bom.organization_id = X_Organization_Id
50: and bom.assembly_item_id = X_Assembly_Item_Id
51: and nvl(bom.alternate_bom_designator,'NONE') =
52: nvl(X_Alternate,'NONE');