APPS.ENG_VALIDATE_REVISED_ITEM dependencies on BOM_BILL_OF_MATERIALS

Line 801: FROM Bom_Bill_Of_Materials

797: IS
798: l_Bill_Exists NUMBER := 0;
799: CURSOR c_CheckPrimary IS
800: SELECT bill_sequence_id
801: FROM Bom_Bill_Of_Materials
802: WHERE assembly_item_id = p_Revised_Item_Id
803: AND organization_id = p_Organization_Id
804: AND alternate_bom_designator is null
805: AND ((assembly_type = 1 and p_Assembly_Type = 1)

Line 890: from BOM_BILL_OF_MATERIALS

886: l_count1 NUMBER := 0;
887: l_count2 NUMBER := 0;
888: cursor pending_on_eco is
889: select 1
890: from BOM_BILL_OF_MATERIALS
891: where bill_sequence_id = p_bill_sequence_id
892: and pending_from_ecn is not null
893: and pending_from_ecn = p_change_notice;
894: cursor reference_common is

Line 896: from BOM_BILL_OF_MATERIALS

892: and pending_from_ecn is not null
893: and pending_from_ecn = p_change_notice;
894: cursor reference_common is
895: select 1
896: from BOM_BILL_OF_MATERIALS
897: where source_bill_sequence_id = p_bill_sequence_id -- R12: Common Bom
898: and source_bill_sequence_id <> bill_sequence_id;
899: BEGIN
900:

Line 975: from BOM_BILL_OF_MATERIALS

971: )RETURN BOOLEAN
972: IS
973: l_dummy NUMBER;
974: cursor common_exists is select common_assembly_item_id
975: from BOM_BILL_OF_MATERIALS
976: where bill_sequence_id = p_bill_sequence_id
977: and bill_sequence_id <> source_bill_sequence_id; --R12
978: BEGIN
979: open common_exists;

Line 1722: FROM bom_bill_of_materials

1718: , p_organization_id NUMBER)
1719: IS
1720:
1721: SELECT 1
1722: FROM bom_bill_of_materials
1723: WHERE assembly_item_id = p_revied_item_id
1724: AND organization_id = p_organization_id
1725: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
1726:

Line 1922: , BOM_BILL_OF_MATERIALS bom

1918:
1919:
1920: SELECT 'Rev Item is only Eco for altenate routing'
1921: FROM ENG_REVISED_ITEMS eri
1922: , BOM_BILL_OF_MATERIALS bom
1923: WHERE bom.alternate_bom_designator IS NOT NULL
1924: AND eri.bill_sequence_id = bom.bill_sequence_id(+)
1925: AND eri.bill_sequence_id IS NOT NULL
1926: AND eri.routing_sequence_id IS NULL

Line 2126: FROM bom_bill_of_materials

2122: l_alternate_bom_designator VARCHAR2(10) := NULL;
2123:
2124: CURSOR c_GetAlternateDesignator IS
2125: SELECT alternate_bom_designator
2126: FROM bom_bill_of_materials
2127: WHERE bill_sequence_id =
2128: nvl(p_rev_item_unexp_rec.bill_sequence_id,
2129: FND_API.G_MISS_NUM);
2130:

Line 2159: bom_bill_of_materials bom

2155: )
2156: IS
2157: SELECT component_sequence_id
2158: FROM bom_inventory_components bic,
2159: bom_bill_of_materials bom
2160: WHERE bic.component_item_id = p_use_up_item_id
2161: AND bic.implementation_date IS NOT NULL
2162: AND bic.bill_sequence_id = bom.bill_sequence_id
2163: AND bom.assembly_item_id = p_revised_item_id