APPS.ENG_ECO_UTIL dependencies on BOM_BILL_OF_MATERIALS

Line 1381: (select 'x' from bom_bill_of_materials

1377: SELECT bcb.component_sequence_id
1378: FROM bom_components_b bcb
1379: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1380: AND exists
1381: (select 'x' from bom_bill_of_materials
1382: where bill_sequence_id = bcb.bill_sequence_id
1383: and organization_id = x_organization_id )
1384: AND (bcb.common_component_sequence_id IS NULL
1385: OR bcb.common_component_sequence_id = bcb.component_sequence_id)

Line 1548: (select 'x' from bom_bill_of_materials

1544: OR bic.common_component_sequence_id = bic.component_sequence_id)
1545: -- This is to ensure that the destination bill's revised item
1546: -- reschedule doesnt affect its components effectivity date
1547: AND exists
1548: (select 'x' from bom_bill_of_materials
1549: where bill_sequence_id = bic.bill_sequence_id
1550: and organization_id = x_organization_id )
1551: AND bic.IMPLEMENTATION_DATE IS NULL;
1552:

Line 1564: (select 'x' from bom_bill_of_materials

1560: SET bic1.DISABLE_DATE = p_effectivity_date
1561: WHERE bic1.CHANGE_NOTICE = x_change_notice
1562: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
1563: AND exists
1564: (select 'x' from bom_bill_of_materials
1565: where bill_sequence_id = bic1.bill_sequence_id
1566: and organization_id = x_organization_id )
1567: AND bic1.IMPLEMENTATION_DATE IS NULL;
1568:

Line 1799: (select 'x' from bom_bill_of_materials

1795: SELECT bcb.component_sequence_id
1796: FROM bom_components_b bcb
1797: WHERE bcb.CHANGE_NOTICE = cp_change_notice
1798: AND exists
1799: (select 'x' from bom_bill_of_materials
1800: where bill_sequence_id = bcb.bill_sequence_id
1801: and organization_id = x_organization_id )
1802: AND (bcb.common_component_sequence_id IS NULL
1803: OR bcb.common_component_sequence_id = bcb.component_sequence_id)

Line 1938: (select 'x' from bom_bill_of_materials

1934: OR bic.common_component_sequence_id = bic.component_sequence_id)
1935: -- This is to ensure that the destination bill's revised item
1936: -- reschedule doesnt affect its components effectivity date
1937: AND exists
1938: (select 'x' from bom_bill_of_materials
1939: where bill_sequence_id = bic.bill_sequence_id
1940: and organization_id = x_organization_id )
1941: AND bic.IMPLEMENTATION_DATE IS NULL;
1942:

Line 1954: (select 'x' from bom_bill_of_materials

1950: SET bic1.DISABLE_DATE = p_effectivity_date
1951: WHERE bic1.CHANGE_NOTICE = x_change_notice
1952: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
1953: AND exists
1954: (select 'x' from bom_bill_of_materials
1955: where bill_sequence_id = bic1.bill_sequence_id
1956: and organization_id = x_organization_id )
1957: AND bic1.IMPLEMENTATION_DATE IS NULL;
1958:

Line 2633: DELETE FROM BOM_BILL_OF_MATERIALS B

2629:
2630: -- Delete the bom header if bill was created by this revised item and
2631: -- nothing else references this
2632:
2633: DELETE FROM BOM_BILL_OF_MATERIALS B
2634: WHERE B.BILL_SEQUENCE_ID in (SELECT BILL_SEQUENCE_ID
2635: FROM ENG_REVISED_ITEMS ERI
2636: WHERE ORGANIZATION_ID = org_id
2637: AND CHANGE_NOTICE = change_order

Line 2648: FROM BOM_BILL_OF_MATERIALS B2

2644: AND (C.CHANGE_NOTICE IS NULL
2645: OR C.CHANGE_NOTICE <> change_order))
2646: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL
2647: AND NOT EXISTS (SELECT NULL
2648: FROM BOM_BILL_OF_MATERIALS B2
2649: WHERE B2.ORGANIZATION_ID = B.ORGANIZATION_ID
2650: AND B2.ASSEMBLY_ITEM_ID = B.ASSEMBLY_ITEM_ID
2651: AND B2.ALTERNATE_BOM_DESIGNATOR IS NOT NULL))
2652: OR

Line 2674: FROM BOM_BILL_OF_MATERIALS BOM

2670: WHERE R.ORGANIZATION_ID = org_id
2671: AND R.CHANGE_NOTICE = change_order
2672: AND R.STATUS_TYPE = 5
2673: AND NOT EXISTS (SELECT 'NO SUCH BILL'
2674: FROM BOM_BILL_OF_MATERIALS BOM
2675: WHERE BOM.BILL_SEQUENCE_ID = R.BILL_SEQUENCE_ID);
2676: END IF;
2677:
2678: