APPS.WIP_SF_STATUS dependencies on WIP_SHOP_FLOOR_STATUSES

Line 17: INSERT INTO WIP_SHOP_FLOOR_STATUSES

13: X_login_id NUMBER := FND_GLOBAL.LOGIN_ID;
14:
15: BEGIN
16:
17: INSERT INTO WIP_SHOP_FLOOR_STATUSES
18: (WIP_ENTITY_ID, ORGANIZATION_ID,
19: OPERATION_SEQ_NUM, SHOP_FLOOR_STATUS_CODE,
20: LINE_ID, INTRAOPERATION_STEP_TYPE,
21: LAST_UPDATE_DATE, LAST_UPDATED_BY,

Line 44: FROM WIP_SHOP_FLOOR_STATUSES

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'
44: FROM WIP_SHOP_FLOOR_STATUSES
45: WHERE WIP_ENTITY_ID = P_wip_entity_id
46: AND OPERATION_SEQ_NUM = P_operation_seq_num
47: AND SHOP_FLOOR_STATUS_CODE = P_shop_floor_status
48: AND ORGANIZATION_ID = P_organization_id

Line 74: DELETE FROM WIP_SHOP_FLOOR_STATUSES WSFS

70: P_shop_floor_status IN VARCHAR2) IS
71:
72: BEGIN
73:
74: DELETE FROM WIP_SHOP_FLOOR_STATUSES WSFS
75: WHERE
76: WSFS.wip_entity_id = P_wip_entity_id
77: AND WSFS.organization_id = P_organization_id
78: AND WSFS.operation_seq_num = P_operation_seq_num

Line 329: WIP_SHOP_FLOOR_STATUSES WSFS

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 */)
333: AND WP.ORGANIZATION_ID = p_org_id

Line 450: wip_shop_floor_statuses ws,

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
454: AND wsc.organization_id = ws.organization_id

Line 505: WIP_SHOP_FLOOR_STATUSES WSFS

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 */)
509: AND WP.ORGANIZATION_ID = p_org_id