DBA Data[Home] [Help]

APPS.WIP_MOVE_VALIDATOR dependencies on WIP_VALID_INTRAOPERATION_STEPS

Line 950: FROM wip_valid_intraoperation_steps wvis,

946: AND (wmti.fm_intraoperation_step_type IS NULL
947: OR
948: (NOT EXISTS
949: (SELECT 'X'
950: FROM wip_valid_intraoperation_steps wvis,
951: wip_operations wo
952: WHERE wvis.organization_id = wmti.organization_id
953: AND wvis.step_lookup_type = wmti.fm_intraoperation_step_type
954: AND wo.organization_id = wmti.organization_id

Line 1183: FROM wip_valid_intraoperation_steps wvis,

1179: AND (wmti.to_intraoperation_step_type IS NULL
1180: OR
1181: (NOT EXISTS
1182: (SELECT 'X'
1183: FROM wip_valid_intraoperation_steps wvis,
1184: wip_operations wo
1185: WHERE wvis.organization_id = wmti.organization_id
1186: AND wvis.step_lookup_type = wmti.to_intraoperation_step_type
1187: AND wo.organization_id = wmti.organization_id