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.BOM_DELETE_GROUPS_API dependencies on WIP_DISCRETE_JOBS

Line 1056: from WIP_DISCRETE_JOBS WDJ

1052: BEGIN
1053: stmt_num := 4;
1054: select count(*)
1055: into job_count
1056: from WIP_DISCRETE_JOBS WDJ
1057: where WDJ.ORGANIZATION_ID = p_organization_id
1058: and WDJ.PRIMARY_ITEM_ID = p_inventory_item_id
1059: and WDJ.STATUS_TYPE <> 12 /*Closed-no charges allowed*/
1060: and rownum = 1; /* get just the first one that */

Line 1071: update WIP_DISCRETE_JOBS WDJ

1067: where WE.ORGANIZATION_ID =p_organization_id
1068: and WE.PRIMARY_ITEM_ID = p_inventory_item_id;
1069:
1070: stmt_num := 6;
1071: update WIP_DISCRETE_JOBS WDJ
1072: set WDJ.PRIMARY_ITEM_ID = base_id,
1073: WDJ.ALTERNATE_BOM_DESIGNATOR = NULL,
1074: WDJ.ALTERNATE_ROUTING_DESIGNATOR = NULL
1075: where WDJ.ORGANIZATION_ID = p_organization_id