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 1045: UPDATE wip_operations wo

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

Line 1048: FROM wip_operations wo1,

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

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

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

Line 5501: INSERT INTO WIP_OPERATIONS

5497: from wip_discrete_jobs
5498: where WIP_ENTITY_ID = p_wip_entity_id;
5499:
5500: l_stmt_num := 30;
5501: INSERT INTO WIP_OPERATIONS
5502: (WIP_ENTITY_ID,
5503: OPERATION_SEQ_NUM,
5504: ORGANIZATION_ID,
5505: LAST_UPDATE_DATE,

Line 5630: FROM WIP_OPERATIONS WO,

5626: DECODE(p_program_app_id, 0, '', p_program_app_id),
5627: p_program_id,
5628: DECODE(p_program_id, 0, '', SYSDATE),
5629: NULL, BD.SCRAP_ACCOUNT, BD.EST_ABSORPTION_ACCOUNT
5630: FROM WIP_OPERATIONS WO,
5631: BOM_DEPARTMENTS BD
5632: WHERE WO.WIP_ENTITY_ID = p_wip_entity_id
5633: AND WO.OPERATION_SEQ_NUM = l_op_seq_incr
5634: AND WO.DEPARTMENT_ID = BD.DEPARTMENT_ID;