APPS.WIP_MOVE_VALIDATOR dependencies on WIP_SHOP_FLOOR_STATUSES

Line 985: wip_shop_floor_statuses ws

981: AND wmti.process_status = WIP_CONSTANTS.RUNNING
982: AND EXISTS
983: (SELECT 'X'
984: FROM wip_shop_floor_status_codes wsc,
985: wip_shop_floor_statuses ws
986: WHERE wsc.organization_id = wmti.organization_id
987: AND ws.organization_id = wmti.organization_id
988: AND ws.wip_entity_id = wmti.wip_entity_id
989: AND (wmti.line_id IS NULL OR ws.line_id = wmti.line_id)

Line 1012: wip_shop_floor_statuses ws,

1008: for i in 1..enums.count loop
1009: SELECT ws.shop_floor_status_code
1010: into l_sf_status
1011: FROM wip_shop_floor_status_codes wsc,
1012: wip_shop_floor_statuses ws,
1013: wip_move_txn_interface wmti
1014: WHERE wsc.organization_id = wmti.organization_id
1015: AND ws.organization_id = wmti.organization_id
1016: AND ws.wip_entity_id = wmti.wip_entity_id

Line 1294: wip_shop_floor_statuses ws

1290: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
1291: AND EXISTS
1292: (SELECT 'X'
1293: FROM wip_shop_floor_status_codes wsc,
1294: wip_shop_floor_statuses ws
1295: WHERE wsc.organization_id = wmti.organization_id
1296: AND ws.organization_id = wmti.organization_id
1297: AND ws.wip_entity_id = wmti.wip_entity_id
1298: AND (wmti.line_id IS NULL OR ws.line_id = wmti.line_id)

Line 1312: wip_shop_floor_statuses ws,

1308: for i in 1..enums.count loop
1309: SELECT ws.shop_floor_status_code
1310: INTO l_sf_status
1311: FROM wip_shop_floor_status_codes wsc,
1312: wip_shop_floor_statuses ws,
1313: wip_move_txn_interface wmti
1314: WHERE wsc.organization_id = wmti.organization_id
1315: AND ws.organization_id = wmti.organization_id
1316: AND ws.wip_entity_id = wmti.wip_entity_id

Line 3217: wip_shop_floor_statuses ws

3213: AND wmti.process_status = WIP_CONSTANTS.RUNNING
3214: AND EXISTS
3215: (SELECT 'X'
3216: FROM wip_shop_floor_status_codes wsc,
3217: wip_shop_floor_statuses ws
3218: WHERE wsc.organization_id = wmti.organization_id
3219: AND ws.organization_id = wmti.organization_id
3220: AND ws.wip_entity_id = wmti.wip_entity_id
3221: AND (wmti.line_id IS NULL OR ws.line_id = wmti.line_id)

Line 3244: wip_shop_floor_statuses ws,

3240: for i in 1..enums.count loop
3241: SELECT ws.shop_floor_status_code
3242: INTO l_sf_status
3243: FROM wip_shop_floor_status_codes wsc,
3244: wip_shop_floor_statuses ws,
3245: wip_move_txn_interface wmti
3246: WHERE wsc.organization_id = wmti.organization_id
3247: AND ws.organization_id = wmti.organization_id
3248: AND ws.wip_entity_id = wmti.wip_entity_id

Line 3278: wip_shop_floor_statuses ws

3274: AND wmti.transaction_type = WIP_CONSTANTS.COMP_TXN
3275: AND EXISTS
3276: (SELECT 'X'
3277: FROM wip_shop_floor_status_codes wsc,
3278: wip_shop_floor_statuses ws
3279: WHERE wsc.organization_id = wmti.organization_id
3280: AND ws.organization_id = wmti.organization_id
3281: AND ws.wip_entity_id = wmti.wip_entity_id
3282: AND (wmti.line_id IS NULL OR ws.line_id = wmti.line_id)

Line 3296: wip_shop_floor_statuses ws,

3292: for i in 1..enums.count loop
3293: SELECT ws.shop_floor_status_code
3294: INTO l_sf_status
3295: FROM wip_shop_floor_status_codes wsc,
3296: wip_shop_floor_statuses ws,
3297: wip_move_txn_interface wmti
3298: WHERE wsc.organization_id = wmti.organization_id
3299: AND ws.organization_id = wmti.organization_id
3300: AND ws.wip_entity_id = wmti.wip_entity_id