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 1153: UPDATE BOM_INVENTORY_COMPONENTS bic

1149: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1150: END IF ;
1151:
1152: -- update revised components EFFECTIVITY_DATE
1153: UPDATE BOM_INVENTORY_COMPONENTS bic
1154: SET bic.EFFECTIVITY_DATE = p_effectivity_date
1155: WHERE bic.CHANGE_NOTICE = x_change_notice
1156: AND (bic.common_component_sequence_id IS NULL
1157: OR bic.common_component_sequence_id = bic.component_sequence_id)

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

1163: and organization_id = x_organization_id )
1164: AND bic.IMPLEMENTATION_DATE IS NULL;
1165:
1166: IF FND_API.to_Boolean( p_debug ) THEN
1167: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1168: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1169: END IF ;
1170:
1171: -- update revised components DISABLE_DATE

Line 1172: UPDATE BOM_INVENTORY_COMPONENTS bic1

1168: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1169: END IF ;
1170:
1171: -- update revised components DISABLE_DATE
1172: UPDATE BOM_INVENTORY_COMPONENTS bic1
1173: SET bic1.DISABLE_DATE = p_effectivity_date
1174: WHERE bic1.CHANGE_NOTICE = x_change_notice
1175: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
1176: AND exists

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

1190: END LOOP;
1191: -- End changes for R12
1192:
1193: IF FND_API.to_Boolean( p_debug ) THEN
1194: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1195: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1196: END IF ;
1197:
1198: -- update operation sequences EFFECTIVITY_DATE

Line 1503: UPDATE BOM_INVENTORY_COMPONENTS bic

1499: END IF ;
1500:
1501:
1502: -- update revised components EFFECTIVITY_DATE
1503: UPDATE BOM_INVENTORY_COMPONENTS bic
1504: SET bic.EFFECTIVITY_DATE = p_effectivity_date
1505: WHERE bic.CHANGE_NOTICE = x_change_notice
1506: AND (bic.common_component_sequence_id IS NULL
1507: OR bic.common_component_sequence_id = bic.component_sequence_id)

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

1513: and organization_id = x_organization_id )
1514: AND bic.IMPLEMENTATION_DATE IS NULL;
1515:
1516: IF FND_API.to_Boolean( p_debug ) THEN
1517: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.EFFECTIVITY_DATE updated ... ' );
1518: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1519: END IF ;
1520:
1521: -- update revised components DISABLE_DATE

Line 1522: UPDATE BOM_INVENTORY_COMPONENTS bic1

1518: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1519: END IF ;
1520:
1521: -- update revised components DISABLE_DATE
1522: UPDATE BOM_INVENTORY_COMPONENTS bic1
1523: SET bic1.DISABLE_DATE = p_effectivity_date
1524: WHERE bic1.CHANGE_NOTICE = x_change_notice
1525: AND bic1.ACD_TYPE = 3 -- ACD Type: Disable
1526: AND exists

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

1540: END LOOP;
1541: -- End changes for R12
1542:
1543: IF FND_API.to_Boolean( p_debug ) THEN
1544: ENG_CHANGE_ACTIONS_UTIL.Write_Debug('BOM_INVENTORY_COMPONENTS.DISABLE_DATE updated ... ' );
1545: ENG_CHANGE_ACTIONS_UTIL.Write_Debug(' SQL%ROWCOUNT = ' || to_char(SQL%ROWCOUNT));
1546: END IF ;
1547:
1548: -- update operation sequences EFFECTIVITY_DATE

Line 2017: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2013:
2014: DELETE FROM BOM_SUBSTITUTE_COMPONENTS SC
2015: WHERE SC.COMPONENT_SEQUENCE_ID IN
2016: (SELECT IC.COMPONENT_SEQUENCE_ID
2017: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2018: WHERE RI.ORGANIZATION_ID = org_id
2019: AND RI.CHANGE_NOTICE = change_order
2020: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2021: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2028: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2024:
2025: DELETE FROM BOM_REFERENCE_DESIGNATORS RD
2026: WHERE RD.COMPONENT_SEQUENCE_ID IN
2027: (SELECT IC.COMPONENT_SEQUENCE_ID
2028: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2029: WHERE RI.ORGANIZATION_ID = org_id
2030: AND RI.CHANGE_NOTICE = change_order
2031: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2032: AND IC.IMPLEMENTATION_DATE IS NULL);

Line 2154: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI

2150: prog_id,
2151: prog_appid,
2152: orig_sysref,
2153: IC.BASIS_TYPE
2154: FROM BOM_INVENTORY_COMPONENTS IC, ENG_REVISED_ITEMS RI
2155: WHERE RI.ORGANIZATION_ID = org_id
2156: AND RI.CHANGE_NOTICE = change_order
2157: AND IC.CHANGE_NOTICE = RI.CHANGE_NOTICE
2158: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID

Line 2162: -- Delete the rows from bom_inventory_components

2158: AND IC.REVISED_ITEM_SEQUENCE_ID = RI.REVISED_ITEM_SEQUENCE_ID
2159: AND RI.BILL_SEQUENCE_ID = IC.BILL_SEQUENCE_ID
2160: AND IC.IMPLEMENTATION_DATE IS NULL;
2161:
2162: -- Delete the rows from bom_inventory_components
2163:
2164: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2165: WHERE CHANGE_NOTICE = change_order
2166: AND IMPLEMENTATION_DATE IS NULL

Line 2164: DELETE FROM BOM_INVENTORY_COMPONENTS IC

2160: AND IC.IMPLEMENTATION_DATE IS NULL;
2161:
2162: -- Delete the rows from bom_inventory_components
2163:
2164: DELETE FROM BOM_INVENTORY_COMPONENTS IC
2165: WHERE CHANGE_NOTICE = change_order
2166: AND IMPLEMENTATION_DATE IS NULL
2167: AND REVISED_ITEM_SEQUENCE_ID IN (SELECT REVISED_ITEM_SEQUENCE_ID
2168: FROM ENG_REVISED_ITEMS ERI

Line 2215: FROM BOM_INVENTORY_COMPONENTS C

2211: AND STATUS_TYPE = 5
2212: AND TRUNC(LAST_UPDATE_DATE) = trunc(sysdate))
2213: AND B.PENDING_FROM_ECN = change_order
2214: AND NOT EXISTS (SELECT NULL
2215: FROM BOM_INVENTORY_COMPONENTS C
2216: WHERE C.BILL_SEQUENCE_ID = B.BILL_SEQUENCE_ID
2217: AND (C.CHANGE_NOTICE IS NULL
2218: OR C.CHANGE_NOTICE <> change_order))
2219: AND ((B.ALTERNATE_BOM_DESIGNATOR IS NULL