eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WIP_DEFAULT_SHOPFLOORMOVE dependencies on WIP_CONSTANTS

Line 57: and (((we.entity_type = WIP_CONSTANTS.DISCRETE)

53: select count(*) into x_valid_ez_complete
54: from WIP_ENTITIES WE
55: where we.wip_entity_id = p_wip_entity_id
56: and we.organization_id = p_org_id
57: and (((we.entity_type = WIP_CONSTANTS.DISCRETE)
58: and not exists (select 'X'
59: from WIP_DISCRETE_JOBS DJ
60: where DJ.WIP_ENTITY_ID = p_wip_entity_id
61: and DJ.ORGANIZATION_ID = p_org_id

Line 63: or (we.entity_type = WIP_CONSTANTS.REPETITIVE)

59: from WIP_DISCRETE_JOBS DJ
60: where DJ.WIP_ENTITY_ID = p_wip_entity_id
61: and DJ.ORGANIZATION_ID = p_org_id
62: and DJ.COMPLETION_SUBINVENTORY IS NOT NULL))
63: or (we.entity_type = WIP_CONSTANTS.REPETITIVE)
64: and not exists (select 'X' from WIP_REPETITIVE_ITEMS WRI
65: where WRI.WIP_ENTITY_ID = p_wip_entity_id
66: and WRI.ORGANIZATION_ID = p_org_id
67: and WRI.LINE_ID = p_line_id

Line 92: and msi.lot_control_code = WIP_CONSTANTS.LOT

88: where we.wip_entity_id = p_wip_entity_id
89: and we.organization_id = p_org_id
90: and msi.inventory_item_id = we.primary_item_id
91: and msi.organization_id = we.organization_id
92: and msi.lot_control_code = WIP_CONSTANTS.LOT
93: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
94: and exists (select 'X'
95: from wip_discrete_jobs wdj
96: where wdj.wip_entity_id = we.wip_entity_id

Line 93: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE

89: and we.organization_id = p_org_id
90: and msi.inventory_item_id = we.primary_item_id
91: and msi.organization_id = we.organization_id
92: and msi.lot_control_code = WIP_CONSTANTS.LOT
93: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
94: and exists (select 'X'
95: from wip_discrete_jobs wdj
96: where wdj.wip_entity_id = we.wip_entity_id
97: and wdj.organization_id = we.organization_id

Line 99: or (we.entity_type = WIP_CONSTANTS.REPETITIVE) );

95: from wip_discrete_jobs wdj
96: where wdj.wip_entity_id = we.wip_entity_id
97: and wdj.organization_id = we.organization_id
98: and wdj.lot_number is null))
99: or (we.entity_type = WIP_CONSTANTS.REPETITIVE) );
100:
101: exception
102: when others then
103: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','validate_lot_control');

Line 143: and wsfs.intraoperation_step_type=WIP_CONSTANTS.TOMOVE

139: and nvl (wo.repetitive_schedule_id, -1) = nvl (p_rep_sched_id, -1)
140: and wo.organization_id = wsfs.organization_id
141: and wo.next_operation_seq_num is null
142: and wo.operation_seq_num = wsfs.operation_seq_num
143: and wsfs.intraoperation_step_type=WIP_CONSTANTS.TOMOVE
144: and wsfsc.shop_floor_status_code = wsfs.shop_floor_status_code
145: and wsfsc.organization_id = wsfs.organization_id
146: and wsfsc.status_move_flag = 2
147: and nvl(wsfsc.disable_date, sysdate + 1) > sysdate;

Line 174: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE

170: from MTL_SYSTEM_ITEMS msi
171: where msi.organization_id = p_org_id
172: and msi.inventory_item_id = we.primary_item_id
173: and msi.revision_qty_control_code=2)
174: and ( ( we.entity_type = WIP_CONSTANTS.DISCRETE
175: and not exists (
176: select 'X'
177: from WIP_DISCRETE_JOBS wdj, MTL_ITEM_REVISIONS MIR
178: where wdj.organization_id = we.organization_id

Line 188: or (we.entity_type = WIP_CONSTANTS.REPETITIVE

184: and mir.revision = wdj.bom_revision
185: )
186: )
187: ))
188: or (we.entity_type = WIP_CONSTANTS.REPETITIVE
189: and not exists (
190: select 'X'
191: from WIP_REPETITIVE_SCHEDULES WRS, MTL_ITEM_REVISIONS MIR
192: where wrs.organization_id = we.organization_id

Line 263: x_txn_type := WIP_CONSTANTS.MOVE_TXN;

259: x_temp NUMBER;
260: x_valid_ez_complete NUMBER;
261:
262: BEGIN
263: x_txn_type := WIP_CONSTANTS.MOVE_TXN;
264: if (p_correction_type = MOVE_FORWARD) then
265:
266: if (p_next_op > p_current_op) then
267: x_current_step := WIP_CONSTANTS.QUEUE;

Line 267: x_current_step := WIP_CONSTANTS.QUEUE;

263: x_txn_type := WIP_CONSTANTS.MOVE_TXN;
264: if (p_correction_type = MOVE_FORWARD) then
265:
266: if (p_next_op > p_current_op) then
267: x_current_step := WIP_CONSTANTS.QUEUE;
268: x_next_step := WIP_CONSTANTS.QUEUE;
269: else
270: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
271: p_rep_sched_id, x_valid_ez_complete);

Line 268: x_next_step := WIP_CONSTANTS.QUEUE;

264: if (p_correction_type = MOVE_FORWARD) then
265:
266: if (p_next_op > p_current_op) then
267: x_current_step := WIP_CONSTANTS.QUEUE;
268: x_next_step := WIP_CONSTANTS.QUEUE;
269: else
270: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
271: p_rep_sched_id, x_valid_ez_complete);
272: if (x_valid_ez_complete = VALID) then

Line 273: x_txn_type := WIP_CONSTANTS.COMP_TXN;

269: else
270: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
271: p_rep_sched_id, x_valid_ez_complete);
272: if (x_valid_ez_complete = VALID) then
273: x_txn_type := WIP_CONSTANTS.COMP_TXN;
274: /*BUG 6146597:If OSP operation is last count point operation, perform easy-completion.*/
275: p_next_op := null;
276: p_next_dept_id := null;
277: x_current_step := WIP_CONSTANTS.QUEUE;

Line 277: x_current_step := WIP_CONSTANTS.QUEUE;

273: x_txn_type := WIP_CONSTANTS.COMP_TXN;
274: /*BUG 6146597:If OSP operation is last count point operation, perform easy-completion.*/
275: p_next_op := null;
276: p_next_dept_id := null;
277: x_current_step := WIP_CONSTANTS.QUEUE;
278: x_next_step := null;
279: else
280: p_next_op := p_current_op;
281: p_next_dept_id := p_current_dept_id;

Line 282: x_current_step := WIP_CONSTANTS.QUEUE;

278: x_next_step := null;
279: else
280: p_next_op := p_current_op;
281: p_next_dept_id := p_current_dept_id;
282: x_current_step := WIP_CONSTANTS.QUEUE;
283: x_next_step := WIP_CONSTANTS.TOMOVE;
284: end if;
285: end if;
286: else

Line 283: x_next_step := WIP_CONSTANTS.TOMOVE;

279: else
280: p_next_op := p_current_op;
281: p_next_dept_id := p_current_dept_id;
282: x_current_step := WIP_CONSTANTS.QUEUE;
283: x_next_step := WIP_CONSTANTS.TOMOVE;
284: end if;
285: end if;
286: else
287: if (p_next_op > p_current_op) then

Line 294: x_current_step := WIP_CONSTANTS.QUEUE;

290: p_next_op := x_temp;
291: x_temp := p_current_dept_id;
292: p_current_dept_id := p_next_dept_id;
293: p_next_dept_id := x_temp;
294: x_current_step := WIP_CONSTANTS.QUEUE;
295: x_next_step := WIP_CONSTANTS.QUEUE;
296: else
297: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
298: p_rep_sched_id, x_valid_ez_complete);

Line 295: x_next_step := WIP_CONSTANTS.QUEUE;

291: x_temp := p_current_dept_id;
292: p_current_dept_id := p_next_dept_id;
293: p_next_dept_id := x_temp;
294: x_current_step := WIP_CONSTANTS.QUEUE;
295: x_next_step := WIP_CONSTANTS.QUEUE;
296: else
297: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
298: p_rep_sched_id, x_valid_ez_complete);
299: if (x_valid_ez_complete = VALID) then

Line 300: x_txn_type := WIP_CONSTANTS.RET_TXN;

296: else
297: validate_last_op(p_wip_entity_id, p_org_id, p_line_id,
298: p_rep_sched_id, x_valid_ez_complete);
299: if (x_valid_ez_complete = VALID) then
300: x_txn_type := WIP_CONSTANTS.RET_TXN;
301: end if;
302: p_next_op := p_current_op;
303: p_next_dept_id := p_current_dept_id;
304: x_current_step := WIP_CONSTANTS.TOMOVE;

Line 304: x_current_step := WIP_CONSTANTS.TOMOVE;

300: x_txn_type := WIP_CONSTANTS.RET_TXN;
301: end if;
302: p_next_op := p_current_op;
303: p_next_dept_id := p_current_dept_id;
304: x_current_step := WIP_CONSTANTS.TOMOVE;
305: x_next_step := WIP_CONSTANTS.QUEUE;
306: end if;
307: end if;
308:

Line 305: x_next_step := WIP_CONSTANTS.QUEUE;

301: end if;
302: p_next_op := p_current_op;
303: p_next_dept_id := p_current_dept_id;
304: x_current_step := WIP_CONSTANTS.TOMOVE;
305: x_next_step := WIP_CONSTANTS.QUEUE;
306: end if;
307: end if;
308:
309: exception

Line 475: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then

471: -- set the primary quantity to job qty if basis type is LOT based
472: -- fix bug 1832111
473: if (l_basis_type = 2) then -- lot based resource
474: if (l_fm_operation_seq_num = l_cur_op_seq) then
475: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then
476: l_primary_quantity := l_cur_qty_in_queue;
477: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then
478: l_primary_quantity := l_cur_qty_to_move;
479: end if;

Line 477: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then

473: if (l_basis_type = 2) then -- lot based resource
474: if (l_fm_operation_seq_num = l_cur_op_seq) then
475: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then
476: l_primary_quantity := l_cur_qty_in_queue;
477: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then
478: l_primary_quantity := l_cur_qty_to_move;
479: end if;
480: elsif (l_fm_operation_seq_num = l_next_op_seq) then
481: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then

Line 481: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then

477: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then
478: l_primary_quantity := l_cur_qty_to_move;
479: end if;
480: elsif (l_fm_operation_seq_num = l_next_op_seq) then
481: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then
482: l_primary_quantity := l_next_qty_in_queue;
483: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then
484: l_primary_quantity := l_next_qty_to_move;
485: end if;

Line 483: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then

479: end if;
480: elsif (l_fm_operation_seq_num = l_next_op_seq) then
481: if (l_fm_intraop_step_type = WIP_CONSTANTS.QUEUE) then
482: l_primary_quantity := l_next_qty_in_queue;
483: elsif (l_fm_intraop_step_type = WIP_CONSTANTS.TOMOVE) then
484: l_primary_quantity := l_next_qty_to_move;
485: end if;
486: end if;
487: -- need to also change the transaction_quantity

Line 1112: IF (l_logLevel <= wip_constants.full_logging) THEN

1108: and rt.wip_operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num
1109: and rt.wip_resource_seq_num = g_OSP_rec.resource_seq_num
1110: and rt.transaction_type = 'DELIVER'
1111: and rt.po_distribution_id is not null) ;
1112: IF (l_logLevel <= wip_constants.full_logging) THEN
1113: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_po_qty_delivered: '||l_total_po_qty_delivered,l_returnStatus);
1114: END IF ;
1115:
1116: begin

Line 1208: IF (l_logLevel <= wip_constants.full_logging) THEN

1204: when others then
1205: fnd_msg_pub.add_exc_msg('WIP_Default_Shopfloormove','get_overcpl_primary_qty: select from MSI');
1206: end;
1207:
1208: IF (l_logLevel <= wip_constants.full_logging) THEN
1209: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_pri_qty_delivered: '||l_total_pri_qty_delivered,l_returnStatus);
1210: END IF;
1211:
1212: begin

Line 1249: and wrs.status_type = WIP_CONSTANTS.RELEASED

1245: and wrs.wip_entity_id = wo.wip_entity_id
1246: and wo.organization_id = wrs.organization_id
1247: and wo.repetitive_schedule_id = wrs.repetitive_schedule_id
1248: and wrs.line_id = g_osp_rec.line_id
1249: and wrs.status_type = WIP_CONSTANTS.RELEASED
1250: and wo.organization_id = g_ShopFloorMove_rec.organization_id
1251: and wo.operation_seq_num = g_ShopFloorMove_rec.fm_operation_seq_num;
1252:
1253: end if ;

Line 1257: IF (l_logLevel <= wip_constants.full_logging) THEN

1253: end if ;
1254:
1255: l_total_qty := l_quantity_in_queue + l_quantity_running + l_quantity_completed ;
1256:
1257: IF (l_logLevel <= wip_constants.full_logging) THEN
1258: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_qty: '||l_total_qty,l_returnStatus);
1259: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_in_queue: '||l_quantity_in_queue,l_returnStatus);
1260: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_running: '||l_quantity_running,l_returnStatus);
1261: wip_logger.log('Get_Overcpl_Primary_Qty: l_quantity_completed: '||l_quantity_completed,l_returnStatus);

Line 1273: IF (l_logLevel <= wip_constants.full_logging) THEN

1269:
1270: l_curr_qty_delivered := nvl(g_ShopFloorMove_rec.primary_quantity,0);
1271: l_total_prev_qty_delivered := l_total_pri_qty_delivered - l_curr_qty_delivered;
1272:
1273: IF (l_logLevel <= wip_constants.full_logging) THEN
1274: wip_logger.log('Get_Overcpl_Primary_Qty: l_curr_qty_delivered: '||l_curr_qty_delivered,l_returnStatus);
1275: wip_logger.log('Get_Overcpl_Primary_Qty: l_total_prev_qty_delivered: '||l_total_prev_qty_delivered,l_returnStatus);
1276: END IF;
1277:

Line 1291: IF (l_logLevel <= wip_constants.full_logging) THEN

1287: /* Modified for bug 6649174 */
1288: --l_remaining_qty := greatest(l_scheduled_quantity, l_quantity_in_queue) - l_total_prev_qty_delivered ; -- Open Qty
1289: l_remaining_qty := l_total_qty - l_total_prev_qty_delivered ; -- Open Qty
1290:
1291: IF (l_logLevel <= wip_constants.full_logging) THEN
1292: wip_logger.log('Get_Overcpl_Primary_Qty: l_remaining_qty: '||l_remaining_qty,l_returnStatus);
1293: END IF;
1294:
1295: /* Modified calculation logic for bug 6649174 */

Line 1300: IF (l_logLevel <= wip_constants.full_logging) THEN

1296: if l_curr_qty_delivered > l_remaining_qty then -- Current Qty is going to overcomplete an Op.
1297:
1298: If ( l_total_prev_qty_delivered >= l_total_qty ) then -- You delivered more quantity last time
1299: l_overcpl_primary_qty := l_curr_qty_delivered;
1300: IF (l_logLevel <= wip_constants.full_logging) THEN
1301: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty1: '||l_overcpl_primary_qty,l_returnStatus);
1302: END IF;
1303: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1304: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;

Line 1305: IF (l_logLevel <= wip_constants.full_logging) THEN

1301: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty1: '||l_overcpl_primary_qty,l_returnStatus);
1302: END IF;
1303: elsif (l_total_pri_qty_delivered > l_total_qty) then -- You are over receiving this time
1304: l_overcpl_primary_qty := l_total_pri_qty_delivered - l_total_qty;
1305: IF (l_logLevel <= wip_constants.full_logging) THEN
1306: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty2: '||l_overcpl_primary_qty,l_returnStatus);
1307: END IF;
1308: end if;
1309:

Line 1316: IF (l_logLevel <= wip_constants.full_logging) THEN

1312:
1313: END IF;
1314: END IF;
1315:
1316: IF (l_logLevel <= wip_constants.full_logging) THEN
1317: wip_logger.log('Get_Overcpl_Primary_Qty: l_overcpl_primary_qty3: '||l_overcpl_primary_qty,l_returnStatus);
1318: END IF;
1319:
1320: RETURN l_overcpl_primary_qty;

Line 1477: RETURN WIP_CONSTANTS.MOVE_VAL;

1473: RETURN g_ShopFloorMove_rec.process_phase;
1474: END IF;
1475:
1476: IF g_ShopFloorMove_rec.source_code = 'RCV' THEN
1477: RETURN WIP_CONSTANTS.MOVE_VAL;
1478: END IF;
1479:
1480: RETURN NULL;
1481:

Line 1498: RETURN WIP_CONSTANTS.PENDING;

1494: RETURN g_ShopFloorMove_rec.process_status;
1495: END IF;
1496:
1497: IF g_ShopFloorMove_rec.source_code = 'RCV' THEN
1498: RETURN WIP_CONSTANTS.PENDING;
1499: END IF;
1500:
1501: RETURN NULL;
1502: