DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on BOM_DEPARTMENTS

Line 2467: FROM bom_departments bd,

2463: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
2464: AND wmti.process_status = WIP_CONSTANTS.RUNNING
2465: AND EXISTS
2466: (SELECT 'X'
2467: FROM bom_departments bd,
2468: wip_operation_resources wor,
2469: wip_operations wo1,
2470: wip_operations wo2
2471: WHERE wor.organization_id = wmti.organization_id

Line 2872: bom_departments bd1,

2868: bd2.department_code,
2869: WIP_CONSTANTS.MOVE_PROC
2870: FROM bom_standard_operations bso1,
2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,
2875: wip_operations wo2
2876: WHERE wo1.organization_id = wmti.organization_id

Line 2873: bom_departments bd2,

2869: WIP_CONSTANTS.MOVE_PROC
2870: FROM bom_standard_operations bso1,
2871: bom_standard_operations bso2,
2872: bom_departments bd1,
2873: bom_departments bd2,
2874: wip_operations wo1,
2875: wip_operations wo2
2876: WHERE wo1.organization_id = wmti.organization_id
2877: AND wo1.wip_entity_id = wmti.wip_entity_id