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 328: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,

324: INTO x_no_move_count
325: FROM WIP_OPERATIONS WOP,
326: WIP_OPERATION_RESOURCES WOR,
327: WIP_PARAMETERS WP,
328: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
329: WIP_SHOP_FLOOR_STATUSES WSFS
330: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
331: 2,/* Run */
332: 3 /* To Move */)

Line 449: FROM wip_shop_floor_status_codes wsc,

445: END IF;
446:
447: SELECT count(*)
448: INTO l_no_move_count
449: FROM wip_shop_floor_status_codes wsc,
450: wip_shop_floor_statuses ws,
451: wip_operations wo1
452: WHERE ws.organization_id = p_org_id
453: AND ws.wip_entity_id = p_wip_id

Line 504: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,

500: INTO x_sf_status
501: FROM WIP_OPERATIONS WOP,
502: WIP_OPERATION_RESOURCES WOR,
503: WIP_PARAMETERS WP,
504: WIP_SHOP_FLOOR_STATUS_CODES WSFSC,
505: WIP_SHOP_FLOOR_STATUSES WSFS
506: WHERE WSFS.INTRAOPERATION_STEP_TYPE IN (1,/* Queue */
507: 2,/* Run */
508: 3 /* To Move */)