APPS.WIP_MOVE_VALIDATOR dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 983: FROM wip_shop_floor_status_codes wsc,

979: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
980: AND wmti.process_status = WIP_CONSTANTS.RUNNING
981: AND EXISTS
982: (SELECT 'X'
983: FROM wip_shop_floor_status_codes wsc,
984: wip_shop_floor_statuses ws
985: WHERE wsc.organization_id = wmti.organization_id
986: AND ws.organization_id = wmti.organization_id
987: AND ws.wip_entity_id = wmti.wip_entity_id

Line 1268: FROM wip_shop_floor_status_codes wsc,

1264: AND wmti.process_status = WIP_CONSTANTS.RUNNING
1265: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1266: AND EXISTS
1267: (SELECT 'X'
1268: FROM wip_shop_floor_status_codes wsc,
1269: wip_shop_floor_statuses ws
1270: WHERE wsc.organization_id = wmti.organization_id
1271: AND ws.organization_id = wmti.organization_id
1272: AND ws.wip_entity_id = wmti.wip_entity_id

Line 3147: FROM wip_shop_floor_status_codes wsc,

3143: AND wmti.process_phase = WIP_CONSTANTS.MOVE_VAL
3144: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3145: AND EXISTS
3146: (SELECT 'X'
3147: FROM wip_shop_floor_status_codes wsc,
3148: wip_shop_floor_statuses ws
3149: WHERE wsc.organization_id = wmti.organization_id
3150: AND ws.organization_id = wmti.organization_id
3151: AND ws.wip_entity_id = wmti.wip_entity_id

Line 3186: FROM wip_shop_floor_status_codes wsc,

3182: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3183: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
3184: AND EXISTS
3185: (SELECT 'X'
3186: FROM wip_shop_floor_status_codes wsc,
3187: wip_shop_floor_statuses ws
3188: WHERE wsc.organization_id = wmti.organization_id
3189: AND ws.organization_id = wmti.organization_id
3190: AND ws.wip_entity_id = wmti.wip_entity_id