DBA Data[Home] [Help]

APPS.BOM_DEPARTMENT_RESOURCES_PKG dependencies on WIP_OPERATIONS

Line 481: (SELECT 1 FROM WIP_OPERATIONS wo,

477: AND bos.DEPARTMENT_ID = X_Department_Id);
478:
479: message_name := 'BOM_CANNOT_DELETE_RES_WIP_OP';
480: SELECT 1 INTO dummy FROM DUAL WHERE NOT EXISTS
481: (SELECT 1 FROM WIP_OPERATIONS wo,
482: WIP_OPERATION_RESOURCES wor
483: WHERE wo.WIP_ENTITY_ID = wor.WIP_ENTITY_ID
484: AND wo.OPERATION_SEQ_NUM = wor.OPERATION_SEQ_NUM
485: AND wo.ORGANIZATION_ID = wor.ORGANIZATION_ID