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_DEPARTMENT_RESOURCES_PKG dependencies on WIP_DISCRETE_JOBS

Line 480: /* bug 9186572 - added WIP_DISCRETE_JOBS to check for the status of job also */

476: AND bor.RESOURCE_ID = X_Resource_Id
477: AND bos.DEPARTMENT_ID = X_Department_Id);
478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: /* bug 9186572 - added WIP_DISCRETE_JOBS to check for the status of job also */
481: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
482: (SELECT 1 FROM WIP_OPERATIONS wo,
483: WIP_OPERATION_RESOURCES wor,
484: WIP_DISCRETE_JOBS wdj

Line 484: WIP_DISCRETE_JOBS wdj

480: /* bug 9186572 - added WIP_DISCRETE_JOBS to check for the status of job also */
481: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
482: (SELECT 1 FROM WIP_OPERATIONS wo,
483: WIP_OPERATION_RESOURCES wor,
484: WIP_DISCRETE_JOBS wdj
485: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID
486: AND wdj.WIP_ENTITY_ID = wo.WIP_ENTITY_ID
487: AND wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
488: AND wo.ORGANIZATION_ID = wor.ORGANIZATION_ID