APPS.WSM_JOBCOPIES_PVT dependencies on WIP_OPERATIONS

Line 48: FROM wip_operations

44: l_stmt_num := 10;
45:
46: SELECT max(operation_seq_num)
47: INTO p_op_seq_num
48: FROM wip_operations
49: WHERE wip_entity_id = p_wip_entity_id
50: AND ((quantity_in_queue <> 0
51: OR quantity_running <> 0
52: OR quantity_waiting_to_move <> 0)

Line 78: FROM wip_operations

74: l_stmt_num := 22;
75:
76: SELECT count(*)
77: INTO l_temp
78: FROM wip_operations
79: WHERE wip_entity_id = p_wip_entity_id;
80:
81: IF (l_temp > 1) THEN -- Completed Job
82: x_err_code := -2;

Line 94: FROM wip_operations

90: -- Check for Unreleased Job Condition
91: l_stmt_num := 25;
92: SELECT max(operation_seq_num)
93: INTO p_op_seq_num
94: FROM wip_operations
95: WHERE wip_entity_id = p_wip_entity_id
96: AND quantity_in_queue = 0
97: AND quantity_running = 0
98: AND quantity_waiting_to_move = 0

Line 136: FROM wip_operations

132: l_qty_TM,
133: l_qty_SCR,
134: p_op_start_date,
135: p_op_comp_date
136: FROM wip_operations
137: WHERE wip_entity_id = p_wip_entity_id
138: AND operation_seq_num = p_op_seq_num;
139:
140: IF l_qty_Q > 0 THEN

Line 1044: UPDATE wip_operations wo

1040: BEGIN
1041:
1042: l_stmt_num := 13;
1043:
1044: UPDATE wip_operations wo
1045: SET wo.wsm_op_seq_num =
1046: (SELECT distinct(bos.operation_seq_num)
1047: FROM wip_operations wo1,
1048: bom_operation_sequences bos

Line 1047: FROM wip_operations wo1,

1043:
1044: UPDATE wip_operations wo
1045: SET wo.wsm_op_seq_num =
1046: (SELECT distinct(bos.operation_seq_num)
1047: FROM wip_operations wo1,
1048: bom_operation_sequences bos
1049: WHERE wo1.wip_entity_id = p_wip_entity_id
1050: AND wo1.wsm_op_seq_num IS NULL
1051: AND wo1.operation_sequence_id = bos.operation_sequence_id

Line 1059: '): Cannot upgrade wip_operations.wsm_op_seq_num for wip_entity_id '||p_wip_entity_id);

1055: AND wsm_op_seq_num IS NULL;
1056: EXCEPTION
1057: WHEN OTHERS THEN
1058: fnd_file.put_line(fnd_file.log, 'WSM_JobCopies_PVT.Create_JobCopies('||l_stmt_num||
1059: '): Cannot upgrade wip_operations.wsm_op_seq_num for wip_entity_id '||p_wip_entity_id);
1060: END;
1061: end if;--check on p_insert_wip
1062: l_stmt_num := 15;
1063:

Line 5270: INSERT INTO WIP_OPERATIONS

5266: from wip_discrete_jobs
5267: where WIP_ENTITY_ID = p_wip_entity_id;
5268:
5269: l_stmt_num := 30;
5270: INSERT INTO WIP_OPERATIONS
5271: (WIP_ENTITY_ID,
5272: OPERATION_SEQ_NUM,
5273: ORGANIZATION_ID,
5274: LAST_UPDATE_DATE,

Line 5399: FROM WIP_OPERATIONS WO,

5395: DECODE(p_program_app_id, 0, '', p_program_app_id),
5396: p_program_id,
5397: DECODE(p_program_id, 0, '', SYSDATE),
5398: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
5399: FROM WIP_OPERATIONS WO,
5400: BOM_DEPARTMENTS BD
5401: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
5402: AND WO.OPERATION_SEQ_NUM = l_op_seq_incr
5403: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID;