APPS.WIP_SF_STATUS dependencies on WIP_SHOP_FLOOR_STATUS_CODES

Line 39: FROM WIP_SHOP_FLOOR_STATUS_CODES

35: ATTRIBUTE1, ATTRIBUTE2, ATTRIBUTE3, ATTRIBUTE4,
36: ATTRIBUTE5, ATTRIBUTE6, ATTRIBUTE7, ATTRIBUTE8,
37: ATTRIBUTE9, ATTRIBUTE10, ATTRIBUTE11, ATTRIBUTE12,
38: ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15
39: FROM WIP_SHOP_FLOOR_STATUS_CODES
40: WHERE ORGANIZATION_ID = P_organization_id
41: AND SHOP_FLOOR_STATUS_CODE = P_shop_floor_status
42: AND NOT EXISTS
43: (SELECT 'testing for duplicates'

Line 123: FROM WIP_SHOP_FLOOR_STATUS_CODES

119: (P_intraoperation_step_type <> WIP_CONSTANTS.TOMOVE));
120:
121: CURSOR status_info IS
122: SELECT 'is the status valid'
123: FROM WIP_SHOP_FLOOR_STATUS_CODES
124: WHERE SHOP_FLOOR_STATUS_CODE = P_shop_floor_status
125: AND ORGANIZATION_ID = P_organization_id
126: AND NVL(DISABLE_DATE, SYSDATE + 1) > SYSDATE;
127:

Line 309: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,

305: INTO x_no_move_count
306: FROM WIP_OPERATIONS WOP,
307: WIP_OPERATION_RESOURCES WOR,
308: WIP_PARAMETERS WP,
309: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
310: WIP_SHOP_FLOOR_STATUSES WSFS
311: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
312: 2,/* Run */
313: 3 /* To Move */)

Line 437: FROM wip_shop_floor_status_codes wsc,

433: END IF;
434:
435: SELECT count(*)
436: INTO l_no_move_count
437: FROM wip_shop_floor_status_codes wsc,
438: wip_shop_floor_statuses ws,
439: wip_operations wo1
440: WHERE ws.organization_id = p_org_id
441: AND ws.wip_entity_id = p_wip_id