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 1794: FROM bom_bill_of_materials

1790: , p_organization_id NUMBER)
1791: IS
1792:
1793: SELECT 1
1794: FROM bom_bill_of_materials
1795: WHERE assembly_item_id = p_revied_item_id
1796: AND organization_id = p_organization_id
1797: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
1798:

Line 1994: , BOM_BILL_OF_MATERIALS bom

1990:
1991:
1992: SELECT 'Rev Item is only Eco for altenate routing'
1993: FROM ENG_REVISED_ITEMS eri
1994: , BOM_BILL_OF_MATERIALS bom
1995: WHERE bom.alternate_bom_designator IS NOT NULL
1996: AND eri.bill_sequence_id = bom.bill_sequence_id(+)
1997: AND eri.bill_sequence_id IS NOT NULL
1998: AND eri.routing_sequence_id IS NULL

Line 2198: FROM bom_bill_of_materials

2194: l_alternate_bom_designator VARCHAR2(10) := NULL;
2195:
2196: CURSOR c_GetAlternateDesignator IS
2197: SELECT alternate_bom_designator
2198: FROM bom_bill_of_materials
2199: WHERE bill_sequence_id =
2200: nvl(p_rev_item_unexp_rec.bill_sequence_id,
2201: FND_API.G_MISS_NUM);
2202:

Line 2231: bom_bill_of_materials bom

2227: )
2228: IS
2229: SELECT component_sequence_id
2230: FROM bom_inventory_components bic,
2231: bom_bill_of_materials bom
2232: WHERE bic.component_item_id = p_use_up_item_id
2233: AND bic.implementation_date IS NOT NULL
2234: AND bic.bill_sequence_id = bom.bill_sequence_id
2235: AND bom.assembly_item_id = p_revised_item_id