[Home] [Help]
4720: AND -wor.operation_seq_num = wro.operation_seq_num (+)
4721: AND wor.phantom_item_id = wro.inventory_item_id (+)
4722: /*bug 3930251 -> insert into WCTI only if there are records in CDO)*/
4723: AND EXISTS
4724: ( SELECT 1 FROM cst_department_overheads cdo
4725: WHERE cdo.organization_id = bd.organization_id
4726: AND cdo.department_id = bd.department_id
4727: )
4728: AND (
5172: /* added for OSFM jump enhancement 2541431 */
5173: AND NVL(wop.skip_flag, WIP_CONSTANTS.NO) <> WIP_CONSTANTS.YES
5174: /*bug 3930251 -> insert into WCTI only if there are records in CDO)*/
5175: AND EXISTS
5176: ( SELECT 1 FROM cst_department_overheads cdo
5177: WHERE cdo.organization_id = bd.organization_id
5178: AND cdo.department_id = bd.department_id
5179: )
5180: AND (