DBA Data[Home] [Help]

APPS.WIP_MOVPROC_PRIV dependencies on CST_DEPARTMENT_OVERHEADS

Line 4853: ( SELECT 1 FROM cst_department_overheads cdo

4849: AND -wor.operation_seq_num = wro.operation_seq_num (+)
4850: AND wor.phantom_item_id = wro.inventory_item_id (+)
4851: /*bug 3930251 -> insert into WCTI only if there are records in CDO)*/
4852: AND EXISTS
4853: ( SELECT 1 FROM cst_department_overheads cdo
4854: WHERE cdo.organization_id = bd.organization_id
4855: AND cdo.department_id = bd.department_id
4856: )
4857: AND (

Line 5305: ( SELECT 1 FROM cst_department_overheads cdo

5301: /* added for OSFM jump enhancement 2541431 */
5302: AND NVL(wop.skip_flag, WIP_CONSTANTS.NO) <> WIP_CONSTANTS.YES
5303: /*bug 3930251 -> insert into WCTI only if there are records in CDO)*/
5304: AND EXISTS
5305: ( SELECT 1 FROM cst_department_overheads cdo
5306: WHERE cdo.organization_id = bd.organization_id
5307: AND cdo.department_id = bd.department_id
5308: )
5309: AND (