APPS.ENG_VALIDATE_REV_COMPONENT dependencies on BOM_BILL_OF_MATERIALS

Line 785: FROM bom_bill_of_materials

781: BEGIN
782: -- If Phantom then Component must be a Bill
783: SELECT 'Valid'
784: INTO l_dummy
785: FROM bom_bill_of_materials
786: WHERE assembly_item_id =
787: g_rev_comp_unexp_rec.component_item_id
788: AND organization_id =
789: g_rev_comp_unexp_rec.organization_id;

Line 1321: FROM BOM_BILL_OF_MATERIALS bom

1317: IS
1318: l_other_orgs BOOLEAN;
1319: CURSOR bom_enabled_in_other_orgs IS
1320: SELECT 1
1321: FROM BOM_BILL_OF_MATERIALS bom
1322: WHERE bom.common_bill_sequence_id =
1323: g_rev_comp_Unexp_rec.bill_sequence_id
1324: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1325: AND NOT EXISTS (SELECT 1

Line 1335: FROM BOM_BILL_OF_MATERIALS bom

1331: );
1332:
1333: CURSOR in_other_orgs IS
1334: SELECT 1
1335: FROM BOM_BILL_OF_MATERIALS bom
1336: WHERE bom.common_bill_sequence_id =
1337: g_rev_comp_Unexp_rec.bill_sequence_id
1338: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1339: AND NOT EXISTS (SELECT 1

Line 1349: FROM BOM_BILL_OF_MATERIALS bom

1345:
1346: CURSOR eng_flag_in_other_orgs
1347: IS
1348: SELECT 1
1349: FROM BOM_BILL_OF_MATERIALS bom
1350: WHERE bom.common_bill_sequence_id =
1351: g_rev_comp_Unexp_rec.bill_sequence_id
1352: AND bom.organization_id <> g_rev_comp_Unexp_rec.organization_id
1353: AND NOT EXISTS (SELECT 1

Line 1397: FROM bom_bill_of_materials

1393: RETURN BOOLEAN
1394: IS
1395: CURSOR c_CheckPrimary IS
1396: SELECT 1
1397: FROM bom_bill_of_materials
1398: WHERE assembly_item_id = g_Rev_Comp_Unexp_Rec.revised_item_id
1399: AND organization_id = g_Rev_Comp_Unexp_Rec.Organization_Id
1400: AND NVL(alternate_bom_designator, 'NONE') = 'NONE';
1401: BEGIN

Line 1463: FROM bom_bill_of_materials bom

1459: WHERE eri.revised_item_sequence_id =
1460: p_rev_comp_Unexp_rec.revised_item_sequence_id
1461: AND eri.bill_sequence_id IS NULL
1462: AND NOT EXISTS (SELECT 1
1463: FROM bom_bill_of_materials bom
1464: WHERE bom.bill_sequence_id =
1465: p_rev_comp_Unexp_rec.bill_sequence_id
1466: );
1467:

Line 1793: bom_bill_of_materials bom

1789: BEGIN
1790: SELECT 'Valid'
1791: INTO l_dummy
1792: FROM eng_revised_items eri,
1793: bom_bill_of_materials bom
1794: WHERE eri.revised_item_sequence_id =
1795: p_Rev_Comp_Unexp_Rec.revised_item_sequence_id
1796: AND bom.bill_sequence_id = eri.bill_sequence_id
1797: AND bom.common_bill_sequence_id <> bom.bill_sequence_id;