eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ENG_ECO_UTIL dependencies on BOM_INVENTORY_COMPONENTS

Line 1540: UPDATE BOM_INVENTORY_COMPONENTS bic

1536: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1537: END IF ;
1538:
1539: -- update revised components EFFECTIVITY_DATE
1540: UPDATE BOM_INVENTORY_COMPONENTS bic
1541: SET bic.EFFECTIVITY_DATE = p_effectivity_date
1542: WHERE bic.CHANGE_NOTICE = x_change_notice
1543: AND (bic.common_component_sequence_id IS NULL
1544: OR bic.common_component_sequence_id = bic.component_sequence_id)

Line 1554: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );

1550: and organization_id = x_organization_id )
1551: AND bic.IMPLEMENTATION_DATE IS NULL;
1552:
1553: IF FND_API.to_Boolean( p_debug ) THEN
1554: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1555: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1556: END IF ;
1557:
1558: -- update revised components DISABLE_DATE

Line 1559: UPDATE BOM_INVENTORY_COMPONENTS bic1

1555: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1556: END IF ;
1557:
1558: -- update revised components DISABLE_DATE
1559: UPDATE BOM_INVENTORY_COMPONENTS bic1
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

Line 1581: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );

1577: END LOOP;
1578: -- End changes for R12
1579:
1580: IF FND_API.to_Boolean( p_debug ) THEN
1581: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1582: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1583: END IF ;
1584:
1585: -- update operation sequences EFFECTIVITY_DATE

Line 1930: UPDATE BOM_INVENTORY_COMPONENTS bic

1926: END IF ;
1927:
1928:
1929: -- update revised components EFFECTIVITY_DATE
1930: UPDATE BOM_INVENTORY_COMPONENTS bic
1931: SET bic.EFFECTIVITY_DATE = p_effectivity_date
1932: WHERE bic.CHANGE_NOTICE = x_change_notice
1933: AND (bic.common_component_sequence_id IS NULL
1934: OR bic.common_component_sequence_id = bic.component_sequence_id)

Line 1944: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );

1940: and organization_id = x_organization_id )
1941: AND bic.IMPLEMENTATION_DATE IS NULL;
1942:
1943: IF FND_API.to_Boolean( p_debug ) THEN
1944: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1945: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1946: END IF ;
1947:
1948: -- update revised components DISABLE_DATE

Line 1949: UPDATE BOM_INVENTORY_COMPONENTS bic1

1945: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1946: END IF ;
1947:
1948: -- update revised components DISABLE_DATE
1949: UPDATE BOM_INVENTORY_COMPONENTS bic1
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

Line 1971: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );

1967: END LOOP;
1968: -- End changes for R12
1969:
1970: IF FND_API.to_Boolean( p_debug ) THEN
1971: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1972: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1973: END IF ;
1974:
1975: -- update operation sequences EFFECTIVITY_DATE

Line 2444: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2440:
2441: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2442: WHERE SC.COMPONENT_SEQUENCE_ID IN
2443: (SELECT IC.COMPONENT_SEQUENCE_ID
2444: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2445: WHERE RI.ORGANIZATION_ID = org_id
2446: AND RI.CHANGE_NOTICE = change_order
2447: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2448: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2455: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2451:
2452: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2453: WHERE RD.COMPONENT_SEQUENCE_ID IN
2454: (SELECT IC.COMPONENT_SEQUENCE_ID
2455: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2456: WHERE RI.ORGANIZATION_ID = org_id
2457: AND RI.CHANGE_NOTICE = change_order
2458: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2459: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2581: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2577: prog_id,
2578: prog_appid,
2579: orig_sysref,
2580: IC.BASIS_TYPE
2581: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2582: WHERE RI.ORGANIZATION_ID = org_id
2583: AND RI.CHANGE_NOTICE = change_order
2584: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
2585: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 2589: -- Delete the rows from bom_inventory_components

2585: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2586: AND RI.BILL_SEQUENCE_ID = IC.BILL_SEQUENCE_ID
2587: AND IC.IMPLEMENTATION_DATE IS NULL;
2588:
2589: -- Delete the rows from bom_inventory_components
2590:
2591: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2592: WHERE CHANGE_NOTICE = change_order
2593: AND IMPLEMENTATION_DATE IS NULL

Line 2591: DELETE FROM BOM_INVENTORY_COMPONENTS IC

2587: AND IC.IMPLEMENTATION_DATE IS NULL;
2588:
2589: -- Delete the rows from bom_inventory_components
2590:
2591: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2592: WHERE CHANGE_NOTICE = change_order
2593: AND IMPLEMENTATION_DATE IS NULL
2594: AND REVISED_ITEM_SEQUENCE_ID IN (SELECT REVISED_ITEM_SEQUENCE_ID
2595: FROM ENG_REVISED_ITEMS ERI

Line 2642: FROM BOM_INVENTORY_COMPONENTS C

2638: AND STATUS_TYPE = 5
2639: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))
2640: AND B.PENDING_FROM_ECN = change_order
2641: AND NOT EXISTS (SELECT NULL
2642: FROM BOM_INVENTORY_COMPONENTS C
2643: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
2644: AND (C.CHANGE_NOTICE IS NULL
2645: OR C.CHANGE_NOTICE <> change_order))
2646: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL