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_MOVPROC_PRIV dependencies on WIP_OPERATIONS

Line 45: -- wip_operations for repetitive schedule allocation

41: move_profile move_profile_rec_t,
42: seq_move NUMBER); -- Sequencing move or not
43:
44: -- this record used to store all necessary info need to change in
45: -- wip_operations for repetitive schedule allocation
46: TYPE update_rsa_rec_t IS RECORD(scheID NUMBER,
47: scheQty NUMBER,
48: loginID NUMBER,
49: reqID NUMBER,

Line 679: * This procedure is used to lock a record in WIP_OPERATIONS

675: END write_mtl_errors;
676:
677: /*****************************************************************************
678: * This procedure is equivalent to witpslw_lock_wipops in wiltps.ppc
679: * This procedure is used to lock a record in WIP_OPERATIONS
680: ****************************************************************************/
681: PROCEDURE lock_wipops(p_gib IN group_rec_t,
682: x_returnStatus OUT NOCOPY VARCHAR2) IS
683:

Line 690: FROM wip_operations wop,

686: SELECT wop.wip_entity_id,
687: wop.operation_seq_num,
688: wop.organization_id,
689: wop.repetitive_schedule_id
690: FROM wip_operations wop,
691: wip_repetitive_schedules wrs,
692: wip_move_txn_interface wmti
693: WHERE wop.organization_id = wmti.organization_id
694: AND wop.wip_entity_id = wmti.wip_entity_id

Line 753: l_errMsg := 'Unable to lock the record in wip_operations';

749: IF(c_wipops%ISOPEN) THEN
750: CLOSE c_wipops;
751: END IF;
752: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
753: l_errMsg := 'Unable to lock the record in wip_operations';
754:
755: IF (l_logLevel <= wip_constants.trace_logging) THEN
756: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
757: p_procReturnStatus => x_returnStatus,

Line 819: FROM wip_operations wo1,

815: wo1.quantity_running run_qty,
816: wo1.quantity_waiting_to_move tomove_qty,
817: wo1.quantity_rejected reject_qty,
818: wo1.quantity_scrapped scrap_qty
819: FROM wip_operations wo1,
820: wip_operations wo2,
821: wip_repetitive_schedules wrs,
822: wip_mtl_allocations_temp wmat
823: WHERE wrs.repetitive_schedule_id = wmat.repetitive_schedule_id(+)

Line 820: wip_operations wo2,

816: wo1.quantity_waiting_to_move tomove_qty,
817: wo1.quantity_rejected reject_qty,
818: wo1.quantity_scrapped scrap_qty
819: FROM wip_operations wo1,
820: wip_operations wo2,
821: wip_repetitive_schedules wrs,
822: wip_mtl_allocations_temp wmat
823: WHERE wrs.repetitive_schedule_id = wmat.repetitive_schedule_id(+)
824: AND wrs.organization_id = wmat.organization_id(+)

Line 1145: l_errMsg := 'wip_operations_INFO.first_operation failed';

1141:
1142: IF(l_first_op_seq_num IS NOT NULL) THEN
1143: x_oc_fm_op := l_first_op_seq_num;
1144: ELSE
1145: l_errMsg := 'wip_operations_INFO.first_operation failed';
1146: raise fnd_api.g_exc_unexpected_error;
1147: END IF;
1148:
1149: IF(p_scheID > 0) THEN

Line 1233: * This procedure is used to update WIP_OPERATIONS table for repetitive sche

1229: END insert_alloc_child;
1230:
1231: /*****************************************************************************
1232: * This procedure is equivalent to wip_update_wo_rs in wiltps.ppc
1233: * This procedure is used to update WIP_OPERATIONS table for repetitive sche
1234: ****************************************************************************/
1235: PROCEDURE update_wo_rs(p_scheCount IN NUMBER,
1236: p_rsa_rec IN update_rsa_tbl_t,
1237: p_txn_date IN DATE,

Line 1278: UPDATE wip_operations wop

1274: END LOOP;
1275:
1276: FOR i IN 1..p_scheCount LOOP
1277:
1278: UPDATE wip_operations wop
1279: SET (date_last_moved,
1280: last_updated_by,
1281: last_update_date,
1282: last_update_login,

Line 1347: FROM wip_operations wop1

1343: DECODE(wop.operation_seq_num, p_rsa_rec(i).toOp,
1344: DECODE(p_rsa_rec(i).toStep,
1345: 5, ROUND(p_rsa_rec(i).scheQty,
1346: WIP_CONSTANTS.INV_MAX_PRECISION), 0), 0))
1347: FROM wip_operations wop1
1348: WHERE wop1.rowid = wop.rowid
1349: AND wop1.organization_id = p_rsa_rec(i).orgID
1350: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1351: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID

Line 1356: FROM wip_operations wop2

1352: AND (wop1.operation_seq_num = p_rsa_rec(i).fmOp
1353: OR wop1.operation_seq_num = p_rsa_rec(i).toOp))
1354: WHERE wop.rowid IN
1355: (SELECT wop2.rowid
1356: FROM wip_operations wop2
1357: WHERE wop2.organization_id = p_rsa_rec(i).orgID
1358: AND wop2.wip_entity_id = p_rsa_rec(i).wipID
1359: AND wop2.repetitive_schedule_id = p_rsa_rec(i).scheID
1360: AND (wop2.operation_seq_num = p_rsa_rec(i).fmOp

Line 1370: UPDATE WIP_OPERATIONS wop

1366: IF(p_rsa_rec(i).fmOp < p_rsa_rec(i).toOp) THEN
1367: l_forward_move := WIP_CONSTANTS.YES;
1368: END IF;
1369:
1370: UPDATE WIP_OPERATIONS wop
1371: SET wop.cumulative_scrap_quantity = wop.cumulative_scrap_quantity +
1372: DECODE(l_forward_move,
1373: WIP_CONSTANTS.YES,p_rsa_rec(i).scheQty,
1374: WIP_CONSTANTS.NO,-1 * p_rsa_rec(i).scheQty,

Line 1378: FROM WIP_OPERATIONS wop1

1374: WIP_CONSTANTS.NO,-1 * p_rsa_rec(i).scheQty,
1375: 0)
1376: WHERE wop.rowid in
1377: (SELECT wop1.rowid
1378: FROM WIP_OPERATIONS wop1
1379: WHERE wop1.organization_id = p_rsa_rec(i).orgID
1380: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1381: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1382: AND wop1.operation_seq_num > LEAST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp)

Line 1385: UPDATE WIP_OPERATIONS wop

1381: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1382: AND wop1.operation_seq_num > LEAST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp)
1383: AND wop1.operation_seq_num <= GREATEST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp));
1384: ELSIF(p_rsa_rec(i).fmStep=WIP_CONSTANTS.SCRAP OR p_rsa_rec(i).toStep=WIP_CONSTANTS.SCRAP) THEN
1385: UPDATE WIP_OPERATIONS wop
1386: SET wop.cumulative_scrap_quantity = wop.cumulative_scrap_quantity +
1387: DECODE(p_rsa_rec(i).toStep,
1388: WIP_CONSTANTS.SCRAP,p_rsa_rec(i).scheQty,
1389: 0) +

Line 1395: FROM WIP_OPERATIONS wop1

1391: WIP_CONSTANTS.SCRAP,-1*p_rsa_rec(i).scheQty,
1392: 0)
1393: WHERE wop.rowid in
1394: (SELECT wop1.rowid
1395: FROM WIP_OPERATIONS wop1
1396: WHERE wop1.organization_id = p_rsa_rec(i).orgID
1397: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1398: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1399: AND wop1.operation_seq_num > DECODE(p_rsa_rec(i).fmStep,

Line 1462: UPDATE wip_operations wop

1458: p_params => l_params,
1459: x_returnStatus => l_returnStatus);
1460: END IF;
1461:
1462: UPDATE wip_operations wop
1463: SET (quantity_in_queue,
1464: last_updated_by,
1465: last_update_date,
1466: last_update_login,

Line 1480: FROM wip_operations wop1,

1476: DECODE(p_gib.request_id, -1, NULL, p_gib.request_id),
1477: DECODE(p_gib.application_id, -1, NULL, p_gib.application_id),
1478: DECODE(p_gib.program_id, -1, NULL, p_gib.program_id),
1479: DECODE(p_gib.request_id, -1, NULL, SYSDATE)
1480: FROM wip_operations wop1,
1481: wip_move_txn_interface wmti1,
1482: wip_move_txn_allocations wma1
1483: WHERE wop1.rowid = wop.rowid
1484: -- The WO rows to be updated are identIFied by the rowids.

Line 1501: FROM wip_operations wop2,

1497: -- is the same as transaction_id. When in BG, THEN the transaction_id
1498: -- must be passed.
1499: WHERE wop.rowid =
1500: (SELECT wop2.rowid
1501: FROM wip_operations wop2,
1502: wip_move_txn_interface wmti2,
1503: wip_move_txn_allocations wma2
1504: WHERE wmti2.group_id = p_gib.group_id
1505: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)

Line 1829: -- update wip_operations

1825: l_update_rsa(i).toOp := l_rs_txn.to_op;
1826: l_update_rsa(i).fmStep := l_rs_txn.fm_step;
1827: l_update_rsa(i).toStep := l_rs_txn.to_step ;
1828: END LOOP;
1829: -- update wip_operations
1830: update_wo_rs(p_scheCount => l_sche_count,
1831: p_rsa_rec => l_update_rsa,
1832: p_txn_date => l_rs_txn.txn_date,
1833: x_returnStatus => x_returnStatus);

Line 2003: * This procedure is used to update WIP_OPERATIONS table for discrete and

1999: END rep_move_alloc;
2000:
2001: /*****************************************************************************
2002: * This procedure is equivalent to wip_update_wo_dj in wiltps.ppc
2003: * This procedure is used to update WIP_OPERATIONS table for discrete and
2004: * lotbased jobs.
2005: ****************************************************************************/
2006: PROCEDURE update_wo_dj(p_fm_op IN NUMBER,
2007: p_fm_step IN NUMBER,

Line 2047: UPDATE wip_operations wop

2043: p_params => l_params,
2044: x_returnStatus => l_returnStatus);
2045: END IF;
2046:
2047: UPDATE wip_operations wop
2048: SET (date_last_moved,
2049: last_updated_by,
2050: last_update_date,
2051: last_update_login,

Line 2131: FROM wip_operations wop1

2127: p_to_op,DECODE(p_to_step,
2128: 5,ROUND(p_qty,WIP_CONSTANTS.INV_MAX_PRECISION),
2129: 0),
2130: 0))
2131: FROM wip_operations wop1
2132: WHERE wop1.rowid = wop.rowid
2133: AND wop1.organization_id = p_org_id
2134: AND wop1.wip_entity_id = p_wip_id
2135: AND (wop1.operation_seq_num = p_fm_op

Line 2139: FROM wip_operations wop2

2135: AND (wop1.operation_seq_num = p_fm_op
2136: OR wop1.operation_seq_num = p_to_op))
2137: WHERE wop.rowid IN
2138: (SELECT wop2.rowid
2139: FROM wip_operations wop2
2140: WHERE wop2.organization_id = p_org_id
2141: AND wop2.wip_entity_id = p_wip_id
2142: AND (wop2.operation_seq_num = p_fm_op
2143: OR wop2.operation_seq_num = p_to_op));

Line 2145: /*Enh#2864382.Update wip_operations.cumulative_scrap_quantity after each

2141: AND wop2.wip_entity_id = p_wip_id
2142: AND (wop2.operation_seq_num = p_fm_op
2143: OR wop2.operation_seq_num = p_to_op));
2144:
2145: /*Enh#2864382.Update wip_operations.cumulative_scrap_quantity after each
2146: scrap or return from scrap txn*/
2147: IF(p_fm_step = WIP_CONSTANTS.SCRAP AND p_to_step = WIP_CONSTANTS.SCRAP) THEN
2148: l_forward_move := WIP_CONSTANTS.NO;
2149: IF(p_fm_op

Line 2153: UPDATE WIP_OPERATIONS wo

2149: IF(p_fm_op 2150: l_forward_move := WIP_CONSTANTS.YES;
2151: END IF;
2152:
2153: UPDATE WIP_OPERATIONS wo
2154: SET wo.cumulative_scrap_quantity = wo.cumulative_scrap_quantity +
2155: DECODE(l_forward_move,
2156: WIP_CONSTANTS.YES, -1*p_qty,
2157: WIP_CONSTANTS.NO, p_qty,

Line 2161: FROM WIP_OPERATIONS wo1

2157: WIP_CONSTANTS.NO, p_qty,
2158: 0)
2159: WHERE wo.rowid in
2160: ( SELECT wo1.rowid
2161: FROM WIP_OPERATIONS wo1
2162: WHERE wo1.organization_id = p_org_id
2163: AND wo1.wip_entity_id = p_wip_id
2164: AND wo1.operation_seq_num > LEAST(p_fm_op,p_to_op)
2165: AND wo1.operation_seq_num <= GREATEST(p_fm_op,p_to_op));

Line 2167: UPDATE WIP_OPERATIONS wo

2163: AND wo1.wip_entity_id = p_wip_id
2164: AND wo1.operation_seq_num > LEAST(p_fm_op,p_to_op)
2165: AND wo1.operation_seq_num <= GREATEST(p_fm_op,p_to_op));
2166: ELSIF(p_fm_step=WIP_CONSTANTS.SCRAP OR p_to_step=WIP_CONSTANTS.SCRAP)THEN
2167: UPDATE WIP_OPERATIONS wo
2168: SET wo.cumulative_scrap_quantity = wo.cumulative_scrap_quantity +
2169: DECODE(p_to_step,
2170: WIP_CONSTANTS.SCRAP,p_qty,
2171: 0) +

Line 2177: FROM WIP_OPERATIONS wo1

2173: WIP_CONSTANTS.SCRAP,-1*p_qty,
2174: 0)
2175: WHERE wo.rowid in
2176: (SELECT wo1.rowid
2177: FROM WIP_OPERATIONS wo1
2178: WHERE wo1.organization_id = p_org_id
2179: AND wo1.wip_entity_id = p_wip_id
2180: AND wo1.operation_seq_num > DECODE(p_fm_step,
2181: WIP_CONSTANTS.SCRAP,p_fm_op,

Line 2214: * not. IF it is enough, update WIP_OPERATIONS.

2210:
2211: /*****************************************************************************
2212: * This procedure is equivalent to witpssq_step_qtys_dj in wiltps.ppc
2213: * This procedure is used to check whether the quantity is enough to move or
2214: * not. IF it is enough, update WIP_OPERATIONS.
2215: ****************************************************************************/
2216: PROCEDURE check_qty_dj(p_gib IN OUT NOCOPY group_rec_t,
2217: x_returnStatus OUT NOCOPY VARCHAR2) IS
2218:

Line 2402: FROM wip_operations wop

2398: l_run_qty,
2399: l_tomove_qty,
2400: l_reject_qty,
2401: l_scrap_qty
2402: FROM wip_operations wop
2403: WHERE wop.organization_id = l_dj_txn.org_id
2404: AND wop.wip_entity_id = l_dj_txn.wip_id
2405: AND wop.operation_seq_num = l_dj_txn.fm_op;
2406:

Line 2498: -- update wip_operations for child move txns

2494: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2495: raise fnd_api.g_exc_unexpected_error;
2496: END IF;
2497:
2498: -- update wip_operations for child move txns
2499: update_wo_dj(p_gib => p_gib,
2500: p_fm_op => l_oc_fm_op,
2501: p_fm_step => WIP_CONSTANTS.QUEUE,
2502: p_to_op => l_dj_txn.fm_op,

Line 2545: -- update wip_operations for parent and normal move txns

2541: END IF; -- l_propagate_job_change_to_po = WIP_CONSTANTS.YES
2542: END IF; -- l_dj_txn.oc_pri_qty <> 0 and customer have PO FPJ
2543: END IF; -- IF parent_txn
2544:
2545: -- update wip_operations for parent and normal move txns
2546: update_wo_dj(p_gib => p_gib,
2547: p_fm_op => l_dj_txn.fm_op,
2548: p_fm_step => l_dj_txn.fm_step,
2549: p_to_op => l_dj_txn.to_op,

Line 3536: wip_operations wop,

3532: bom_resources br,
3533: cst_activities ca,
3534: wip_operation_resources wor,
3535: wip_discrete_jobs wdj,
3536: wip_operations wop,
3537: wip_move_txn_interface wmti
3538: WHERE wmti.group_id = p_gib.group_id
3539: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3540: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 3748: wip_operations wop,

3744: bom_resources br,
3745: cst_activities ca,
3746: wip_operation_resources wor,
3747: wip_move_txn_allocations wma,
3748: wip_operations wop,
3749: wip_move_txn_interface wmti
3750: WHERE wmti.group_id = p_gib.group_id
3751: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3752: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 3989: wip_operations wop,

3985: bom_resources br,
3986: cst_activities ca,
3987: wip_operation_resources wor,
3988: wip_discrete_jobs wdj,
3989: wip_operations wop,
3990: wip_move_txn_interface wmti
3991: WHERE wmti.group_id = p_gib.group_id
3992: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3993: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 4200: wip_operations wop,

4196: bom_resources br,
4197: cst_activities ca,
4198: wip_operation_resources wor,
4199: wip_move_txn_allocations wma,
4200: wip_operations wop,
4201: wip_move_txn_interface wmti
4202: WHERE wmti.group_id = p_gib.group_id
4203: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
4204: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 4409: wip_operations wop,

4405: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
4406: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4407:
4408: FROM wip_operation_resources wor,
4409: wip_operations wop,
4410: wip_move_txn_allocations wma,
4411: wip_cost_txn_interface wci,
4412: wip_move_txn_interface wmti
4413: WHERE wmti.group_id = p_gib.group_id

Line 4823: wip_operations wop,

4819: NULL, -- repetitive_schedule_id
4820: MAX(wdj.project_id),
4821: MAX(wdj.task_id)
4822: FROM bom_departments bd,
4823: wip_operations wop,
4824: wip_operation_resources wor,
4825: wip_discrete_jobs wdj,
4826: wip_move_txn_interface wmti,
4827: wip_requirement_operations WRO

Line 5046: wip_operations wop,

5042: NULL, -- po_line_id
5043: NULL -- repetitive_schedule_id
5044: FROM bom_departments bd,
5045: wip_move_txn_allocations wma,
5046: wip_operations wop,
5047: wip_move_txn_interface wmti,
5048: wip_operation_resources wor
5049: WHERE wmti.group_id = p_gib.group_id
5050: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5282: wip_operations wop,

5278: NULL, -- repetitive_schedule_id
5279: MAX(wdj.project_id),
5280: MAX(wdj.task_id)
5281: FROM bom_departments bd,
5282: wip_operations wop,
5283: wip_operation_resources wor,
5284: wip_discrete_jobs wdj,
5285: wip_move_txn_interface wmti
5286: WHERE wmti.group_id = p_gib.group_id

Line 5498: wip_operations wop,

5494: NULL, -- po_line_id
5495: wma.repetitive_schedule_id
5496: FROM bom_departments bd,
5497: wip_move_txn_allocations wma,
5498: wip_operations wop,
5499: wip_move_txn_interface wmti,
5500: wip_operation_resources wor
5501: WHERE wmti.group_id = p_gib.group_id
5502: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5692: wip_operations wop,

5688: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
5689: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
5690: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
5691: FROM wip_move_txn_allocations wma,
5692: wip_operations wop,
5693: wip_cost_txn_interface wci,
5694: wip_move_txn_interface wmti
5695: WHERE wmti.group_id = p_gib.group_id
5696: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5838: wip_operations wo,

5834: wmti.organization_id org_id,
5835: wo.operation_seq_num op_seq_num,
5836: wmti.overcompletion_primary_qty oc_qty
5837: FROM wip_move_txn_interface wmti,
5838: wip_operations wo,
5839: wip_operation_resources wor,
5840: wip_discrete_jobs wdj
5841: WHERE wmti.group_id = p_group_id
5842: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5867: wip_operations wo,

5863: wmti.organization_id org_id,
5864: wo.operation_seq_num op_seq_num,
5865: wmti.overcompletion_primary_qty oc_qty
5866: FROM wip_move_txn_interface wmti,
5867: wip_operations wo,
5868: wip_operation_resources wor,
5869: wip_repetitive_schedules wrs
5870: WHERE wmti.group_id = p_group_id
5871: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 6071: wip_operations wo1,

6067: fnd_user fu,
6068: bom_departments bd,
6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,
6073: wip_parameters wp /*ER 4276433*/
6074: WHERE wmti.group_id = p_gib.group_id
6075: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6072: wip_operations wo2,

6068: bom_departments bd,
6069: hr_organization_information hoi,
6070: wip_discrete_jobs wdj,
6071: wip_operations wo1,
6072: wip_operations wo2,
6073: wip_parameters wp /*ER 4276433*/
6074: WHERE wmti.group_id = p_gib.group_id
6075: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6076: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 6283: wip_operations wo1,

6279: hr_organization_information hoi,
6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6284: wip_operations wo2,
6285: wip_move_txn_allocations wma,
6286: wip_move_txn_interface wmti,
6287: wip_parameters wp /*ER 4276433*/

Line 6284: wip_operations wo2,

6280: wip_entities we,
6281: wip_repetitive_schedules wrs,
6282: wip_operation_resources wor,
6283: wip_operations wo1,
6284: wip_operations wo2,
6285: wip_move_txn_allocations wma,
6286: wip_move_txn_interface wmti,
6287: wip_parameters wp /*ER 4276433*/
6288: WHERE wmti.group_id = p_gib.group_id

Line 6495: wip_operations wo1,

6491: fnd_user fu,
6492: bom_departments bd,
6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,
6497: wip_parameters wp /*ER 4276433*/
6498: WHERE wmti.group_id = p_gib.group_id
6499: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6496: wip_operations wo2,

6492: bom_departments bd,
6493: hr_organization_information hoi,
6494: wip_discrete_jobs wdj,
6495: wip_operations wo1,
6496: wip_operations wo2,
6497: wip_parameters wp /*ER 4276433*/
6498: WHERE wmti.group_id = p_gib.group_id
6499: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6500: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 6725: wip_operations wo1,

6721: hr_organization_information hoi,
6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6726: wip_operations wo2,
6727: wip_move_txn_allocations wma,
6728: wip_move_txn_interface wmti,
6729: wip_parameters wp /*ER 4276433*/

Line 6726: wip_operations wo2,

6722: wip_operation_resources wor,
6723: wip_repetitive_schedules wrs,
6724: wip_entities we,
6725: wip_operations wo1,
6726: wip_operations wo2,
6727: wip_move_txn_allocations wma,
6728: wip_move_txn_interface wmti,
6729: wip_parameters wp /*ER 4276433*/
6730: WHERE wmti.group_id = p_gib.group_id

Line 6910: wip_operations wo,

6906: wor.autocharge_type autocharge_type
6907: FROM bom_resources br,
6908: mtl_units_of_measure muom,
6909: wip_operation_resources wor,
6910: wip_operations wo,
6911: wip_move_txn_interface wmti
6912: WHERE wmti.group_id = p_group_id
6913: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6914: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 7131: * WIP_OPERATIONS

7127:
7128: /*****************************************************************************
7129: * This procedure is equivalent to witpsuc_op_units_complete in wiltps5.ppc
7130: * This procedure is used to update operation unit complete in
7131: * WIP_OPERATIONS
7132: ****************************************************************************/
7133: PROCEDURE update_complete_qty(p_gib IN group_rec_t,
7134: p_txn_id IN NUMBER := NULL,
7135: x_returnStatus OUT NOCOPY VARCHAR2) IS

Line 7160: UPDATE wip_operations wop

7156:
7157: /*------------------------------------------------------------+
7158: | Update quantity_completed
7159: +------------------------------------------------------------*/
7160: UPDATE wip_operations wop
7161: SET (quantity_completed,
7162: last_updated_by,
7163: last_update_date,
7164: last_update_login,

Line 7207: FROM wip_operations wop1,

7203: DECODE(p_gib.request_id,-1,NULL,p_gib.request_id),
7204: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
7205: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
7206: DECODE(p_gib.request_id,-1,NULL,SYSDATE)-- program_update_date
7207: FROM wip_operations wop1,
7208: wip_move_txn_allocations wma1,
7209: wip_move_txn_interface wmti
7210: WHERE wop1.rowid = wop.rowid
7211: AND wmti.group_id = p_gib.group_id

Line 7256: FROM wip_operations wop2,

7252: AND wmti.fm_intraoperation_step_type > WIP_CONSTANTS.RUN)))
7253: ))
7254: WHERE wop.rowid IN
7255: (SELECT wop2.rowid
7256: FROM wip_operations wop2,
7257: wip_move_txn_allocations wma2,
7258: wip_move_txn_interface wmti
7259: WHERE wop2.organization_id = wmti.organization_id
7260: AND wmti.group_id = p_gib.group_id

Line 7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');

7304: -- IF debug message level = 2, write statement below to log file
7305: IF (l_logLevel <= wip_constants.full_logging) THEN
7306: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7307: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7308: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7309: l_msg := fnd_message.get;
7310: wip_logger.log(p_msg => l_msg,
7311: x_returnStatus => l_returnStatus);
7312: END IF;

Line 7760: * of wip_operations if applicable(LIFO, FIFO, and average costing)

7756: END snapshot_background;
7757:
7758: /*****************************************************************************
7759: * This procedure will be used to update quantity_completed, and take snapshot
7760: * of wip_operations if applicable(LIFO, FIFO, and average costing)
7761: ****************************************************************************/
7762: PROCEDURE update_wo_and_snapshot(p_gib IN group_rec_t,
7763: x_returnStatus OUT NOCOPY VARCHAR2) IS
7764: CURSOR c_move_rec IS

Line 8136: from wip_operations

8132: AND (select sum(quantity_in_queue)
8133: + sum(quantity_running)
8134: + sum(quantity_waiting_to_move)
8135: + sum(quantity_rejected)
8136: from wip_operations
8137: where wip_entity_id = wdj2.wip_entity_id
8138: and organization_id = wdj2.organization_id) = 0);
8139:
8140: UPDATE wip_discrete_jobs wdj

Line 8190: FROM wip_operations wo

8186: wrs.quantity_completed) -
8187: SUM(NVL(wo.quantity_scrapped, 0))),
8188: 1, WIP_CONSTANTS.RELEASED,
8189: WIP_CONSTANTS.COMP_CHRG)
8190: FROM wip_operations wo
8191: WHERE wo.organization_id = wrs.organization_id
8192: AND wo.repetitive_schedule_id = wrs.repetitive_schedule_id)
8193: WHERE wrs.status_type IN (WIP_CONSTANTS.RELEASED,
8194: WIP_CONSTANTS.COMP_CHRG)

Line 8538: FROM wip_operations

8534: /* fix bug 6607192(FP 6348222): Cancel the attached PO with the job when Scrap Txn
8535: is happening for all the job qty */
8536: SELECT (scheduled_quantity - quantity_scrapped - cumulative_scrap_quantity)
8537: into l_update_po_qty
8538: FROM wip_operations
8539: WHERE wip_entity_id = l_update_po.job_id
8540: AND nvl(repetitive_schedule_id,0) = nvl(l_update_po.rep_id,0)
8541: AND operation_seq_num = l_update_po.fm_op
8542: AND organization_id = l_update_po.org_id;

Line 8883: wip_operations wop,

8879: wmti.qa_collection_id qa_collection_id,
8880: Decode(wmti.entity_type,5,'Y') -- FP bug 7315664 for bug 7281164
8881: FROM wip_move_txn_interface wmti,
8882: mtl_item_locations mil,
8883: wip_operations wop,
8884: mtl_system_items msi,
8885: wip_discrete_jobs wdj
8886: WHERE wmti.group_id = p_gib.group_id
8887: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 9022: wip_operations wop,

9018: -- populate this value for EZ completion/return because
9019: -- material processor need this value to enable quality
9020: wmti.qa_collection_id qa_collection_id
9021: FROM wip_move_txn_interface wmti,
9022: wip_operations wop,
9023: mtl_system_items msi,
9024: wip_repetitive_schedules wrs,
9025: wip_repetitive_items wri
9026: WHERE wmti.group_id = p_gib.group_id

Line 9651: -- Lock record in WIP_OPERATIONS table

9647: p_params => l_params,
9648: x_returnStatus => l_returnStatus);
9649: END IF;
9650:
9651: -- Lock record in WIP_OPERATIONS table
9652: lock_wipops(p_gib => p_gib,
9653: x_returnStatus => x_returnStatus);
9654:
9655: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 9682: -- Lock record in WIP_OPERATIONS table

9678: raise fnd_api.g_exc_unexpected_error;
9679: END IF; -- check return status
9680: END IF; -- check discrete and OSFM jobs
9681:
9682: -- Lock record in WIP_OPERATIONS table
9683: -- Update the WRO quantities for the Overcompletion
9684: update_wro(p_gib => p_gib,
9685: x_returnStatus => x_returnStatus);
9686: