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 1061: from WIP_DISCRETE_JOBS WDJ

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

Line 1076: update WIP_DISCRETE_JOBS WDJ

1072: where WE.ORGANIZATION_ID =p_organization_id
1073: and WE.PRIMARY_ITEM_ID = p_inventory_item_id;
1074:
1075: stmt_num := 6;
1076: update WIP_DISCRETE_JOBS WDJ
1077: set WDJ.PRIMARY_ITEM_ID = base_id,
1078: WDJ.ALTERNATE_BOM_DESIGNATOR = NULL,
1079: WDJ.ALTERNATE_ROUTING_DESIGNATOR = NULL
1080: where WDJ.ORGANIZATION_ID = p_organization_id