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 558: * This procedure is used to lock a record in WIP_OPERATIONS

554: END write_mtl_errors;
555:
556: /*****************************************************************************
557: * This procedure is equivalent to witpslw_lock_wipops in wiltps.ppc
558: * This procedure is used to lock a record in WIP_OPERATIONS
559: ****************************************************************************/
560: PROCEDURE lock_wipops(p_gib IN group_rec_t,
561: x_returnStatus OUT NOCOPY VARCHAR2) IS
562:

Line 569: FROM wip_operations wop,

565: SELECT wop.wip_entity_id,
566: wop.operation_seq_num,
567: wop.organization_id,
568: wop.repetitive_schedule_id
569: FROM wip_operations wop,
570: wip_repetitive_schedules wrs,
571: wip_move_txn_interface wmti
572: WHERE wop.organization_id = wmti.organization_id
573: AND wop.wip_entity_id = wmti.wip_entity_id

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

628: IF(c_wipops%ISOPEN) THEN
629: CLOSE c_wipops;
630: END IF;
631: x_returnStatus := fnd_api.g_ret_sts_unexp_error;
632: l_errMsg := 'Unable to lock the record in wip_operations';
633:
634: IF (l_logLevel <= wip_constants.trace_logging) THEN
635: wip_logger.exitPoint(p_procName => 'wip_movProc_priv.lock_wipops',
636: p_procReturnStatus => x_returnStatus,

Line 698: FROM wip_operations wo1,

694: wo1.quantity_running run_qty,
695: wo1.quantity_waiting_to_move tomove_qty,
696: wo1.quantity_rejected reject_qty,
697: wo1.quantity_scrapped scrap_qty
698: FROM wip_operations wo1,
699: wip_operations wo2,
700: wip_repetitive_schedules wrs,
701: wip_mtl_allocations_temp wmat
702: WHERE wrs.repetitive_schedule_id = wmat.repetitive_schedule_id(+)

Line 699: wip_operations wo2,

695: wo1.quantity_waiting_to_move tomove_qty,
696: wo1.quantity_rejected reject_qty,
697: wo1.quantity_scrapped scrap_qty
698: FROM wip_operations wo1,
699: wip_operations wo2,
700: wip_repetitive_schedules wrs,
701: wip_mtl_allocations_temp wmat
702: WHERE wrs.repetitive_schedule_id = wmat.repetitive_schedule_id(+)
703: AND wrs.organization_id = wmat.organization_id(+)

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

1020:
1021: IF(l_first_op_seq_num IS NOT NULL) THEN
1022: x_oc_fm_op := l_first_op_seq_num;
1023: ELSE
1024: l_errMsg := 'wip_operations_INFO.first_operation failed';
1025: raise fnd_api.g_exc_unexpected_error;
1026: END IF;
1027:
1028: IF(p_scheID > 0) THEN

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

1108: END insert_alloc_child;
1109:
1110: /*****************************************************************************
1111: * This procedure is equivalent to wip_update_wo_rs in wiltps.ppc
1112: * This procedure is used to update WIP_OPERATIONS table for repetitive sche
1113: ****************************************************************************/
1114: PROCEDURE update_wo_rs(p_scheCount IN NUMBER,
1115: p_rsa_rec IN update_rsa_tbl_t,
1116: p_txn_date IN DATE,

Line 1157: UPDATE wip_operations wop

1153: END LOOP;
1154:
1155: FOR i IN 1..p_scheCount LOOP
1156:
1157: UPDATE wip_operations wop
1158: SET (date_last_moved,
1159: last_updated_by,
1160: last_update_date,
1161: last_update_login,

Line 1226: FROM wip_operations wop1

1222: DECODE(wop.operation_seq_num, p_rsa_rec(i).toOp,
1223: DECODE(p_rsa_rec(i).toStep,
1224: 5, ROUND(p_rsa_rec(i).scheQty,
1225: WIP_CONSTANTS.INV_MAX_PRECISION), 0), 0))
1226: FROM wip_operations wop1
1227: WHERE wop1.rowid = wop.rowid
1228: AND wop1.organization_id = p_rsa_rec(i).orgID
1229: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1230: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID

Line 1235: FROM wip_operations wop2

1231: AND (wop1.operation_seq_num = p_rsa_rec(i).fmOp
1232: OR wop1.operation_seq_num = p_rsa_rec(i).toOp))
1233: WHERE wop.rowid IN
1234: (SELECT wop2.rowid
1235: FROM wip_operations wop2
1236: WHERE wop2.organization_id = p_rsa_rec(i).orgID
1237: AND wop2.wip_entity_id = p_rsa_rec(i).wipID
1238: AND wop2.repetitive_schedule_id = p_rsa_rec(i).scheID
1239: AND (wop2.operation_seq_num = p_rsa_rec(i).fmOp

Line 1249: UPDATE WIP_OPERATIONS wop

1245: IF(p_rsa_rec(i).fmOp < p_rsa_rec(i).toOp) THEN
1246: l_forward_move := WIP_CONSTANTS.YES;
1247: END IF;
1248:
1249: UPDATE WIP_OPERATIONS wop
1250: SET wop.cumulative_scrap_quantity = wop.cumulative_scrap_quantity +
1251: DECODE(l_forward_move,
1252: WIP_CONSTANTS.YES,p_rsa_rec(i).scheQty,
1253: WIP_CONSTANTS.NO,-1 * p_rsa_rec(i).scheQty,

Line 1257: FROM WIP_OPERATIONS wop1

1253: WIP_CONSTANTS.NO,-1 * p_rsa_rec(i).scheQty,
1254: 0)
1255: WHERE wop.rowid in
1256: (SELECT wop1.rowid
1257: FROM WIP_OPERATIONS wop1
1258: WHERE wop1.organization_id = p_rsa_rec(i).orgID
1259: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1260: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1261: AND wop1.operation_seq_num > LEAST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp)

Line 1264: UPDATE WIP_OPERATIONS wop

1260: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1261: AND wop1.operation_seq_num > LEAST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp)
1262: AND wop1.operation_seq_num <= GREATEST(p_rsa_rec(i).fmOp,p_rsa_rec(i).toOp));
1263: ELSIF(p_rsa_rec(i).fmStep=WIP_CONSTANTS.SCRAP OR p_rsa_rec(i).toStep=WIP_CONSTANTS.SCRAP) THEN
1264: UPDATE WIP_OPERATIONS wop
1265: SET wop.cumulative_scrap_quantity = wop.cumulative_scrap_quantity +
1266: DECODE(p_rsa_rec(i).toStep,
1267: WIP_CONSTANTS.SCRAP,p_rsa_rec(i).scheQty,
1268: 0) +

Line 1274: FROM WIP_OPERATIONS wop1

1270: WIP_CONSTANTS.SCRAP,-1*p_rsa_rec(i).scheQty,
1271: 0)
1272: WHERE wop.rowid in
1273: (SELECT wop1.rowid
1274: FROM WIP_OPERATIONS wop1
1275: WHERE wop1.organization_id = p_rsa_rec(i).orgID
1276: AND wop1.wip_entity_id = p_rsa_rec(i).wipID
1277: AND wop1.repetitive_schedule_id = p_rsa_rec(i).scheID
1278: AND wop1.operation_seq_num > DECODE(p_rsa_rec(i).fmStep,

Line 1341: UPDATE wip_operations wop

1337: p_params => l_params,
1338: x_returnStatus => l_returnStatus);
1339: END IF;
1340:
1341: UPDATE wip_operations wop
1342: SET (quantity_in_queue,
1343: last_updated_by,
1344: last_update_date,
1345: last_update_login,

Line 1359: FROM wip_operations wop1,

1355: DECODE(p_gib.request_id, -1, NULL, p_gib.request_id),
1356: DECODE(p_gib.application_id, -1, NULL, p_gib.application_id),
1357: DECODE(p_gib.program_id, -1, NULL, p_gib.program_id),
1358: DECODE(p_gib.request_id, -1, NULL, SYSDATE)
1359: FROM wip_operations wop1,
1360: wip_move_txn_interface wmti1,
1361: wip_move_txn_allocations wma1
1362: WHERE wop1.rowid = wop.rowid
1363: -- The WO rows to be updated are identIFied by the rowids.

Line 1380: FROM wip_operations wop2,

1376: -- is the same as transaction_id. When in BG, THEN the transaction_id
1377: -- must be passed.
1378: WHERE wop.rowid =
1379: (SELECT wop2.rowid
1380: FROM wip_operations wop2,
1381: wip_move_txn_interface wmti2,
1382: wip_move_txn_allocations wma2
1383: WHERE wmti2.group_id = p_gib.group_id
1384: AND TRUNC(wmti2.transaction_date) = TRUNC(p_gib.txn_date)

Line 1708: -- update wip_operations

1704: l_update_rsa(i).toOp := l_rs_txn.to_op;
1705: l_update_rsa(i).fmStep := l_rs_txn.fm_step;
1706: l_update_rsa(i).toStep := l_rs_txn.to_step ;
1707: END LOOP;
1708: -- update wip_operations
1709: update_wo_rs(p_scheCount => l_sche_count,
1710: p_rsa_rec => l_update_rsa,
1711: p_txn_date => l_rs_txn.txn_date,
1712: x_returnStatus => x_returnStatus);

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

1878: END rep_move_alloc;
1879:
1880: /*****************************************************************************
1881: * This procedure is equivalent to wip_update_wo_dj in wiltps.ppc
1882: * This procedure is used to update WIP_OPERATIONS table for discrete and
1883: * lotbased jobs.
1884: ****************************************************************************/
1885: PROCEDURE update_wo_dj(p_fm_op IN NUMBER,
1886: p_fm_step IN NUMBER,

Line 1926: UPDATE wip_operations wop

1922: p_params => l_params,
1923: x_returnStatus => l_returnStatus);
1924: END IF;
1925:
1926: UPDATE wip_operations wop
1927: SET (date_last_moved,
1928: last_updated_by,
1929: last_update_date,
1930: last_update_login,

Line 2010: FROM wip_operations wop1

2006: p_to_op,DECODE(p_to_step,
2007: 5,ROUND(p_qty,WIP_CONSTANTS.INV_MAX_PRECISION),
2008: 0),
2009: 0))
2010: FROM wip_operations wop1
2011: WHERE wop1.rowid = wop.rowid
2012: AND wop1.organization_id = p_org_id
2013: AND wop1.wip_entity_id = p_wip_id
2014: AND (wop1.operation_seq_num = p_fm_op

Line 2018: FROM wip_operations wop2

2014: AND (wop1.operation_seq_num = p_fm_op
2015: OR wop1.operation_seq_num = p_to_op))
2016: WHERE wop.rowid IN
2017: (SELECT wop2.rowid
2018: FROM wip_operations wop2
2019: WHERE wop2.organization_id = p_org_id
2020: AND wop2.wip_entity_id = p_wip_id
2021: AND (wop2.operation_seq_num = p_fm_op
2022: OR wop2.operation_seq_num = p_to_op));

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

2020: AND wop2.wip_entity_id = p_wip_id
2021: AND (wop2.operation_seq_num = p_fm_op
2022: OR wop2.operation_seq_num = p_to_op));
2023:
2024: /*Enh#2864382.Update wip_operations.cumulative_scrap_quantity after each
2025: scrap or return from scrap txn*/
2026: IF(p_fm_step = WIP_CONSTANTS.SCRAP AND p_to_step = WIP_CONSTANTS.SCRAP) THEN
2027: l_forward_move := WIP_CONSTANTS.NO;
2028: IF(p_fm_op

Line 2032: UPDATE WIP_OPERATIONS wo

2028: IF(p_fm_op 2029: l_forward_move := WIP_CONSTANTS.YES;
2030: END IF;
2031:
2032: UPDATE WIP_OPERATIONS wo
2033: SET wo.cumulative_scrap_quantity = wo.cumulative_scrap_quantity +
2034: DECODE(l_forward_move,
2035: WIP_CONSTANTS.YES, -1*p_qty,
2036: WIP_CONSTANTS.NO, p_qty,

Line 2040: FROM WIP_OPERATIONS wo1

2036: WIP_CONSTANTS.NO, p_qty,
2037: 0)
2038: WHERE wo.rowid in
2039: ( SELECT wo1.rowid
2040: FROM WIP_OPERATIONS wo1
2041: WHERE wo1.organization_id = p_org_id
2042: AND wo1.wip_entity_id = p_wip_id
2043: AND wo1.operation_seq_num > LEAST(p_fm_op,p_to_op)
2044: AND wo1.operation_seq_num <= GREATEST(p_fm_op,p_to_op));

Line 2046: UPDATE WIP_OPERATIONS wo

2042: AND wo1.wip_entity_id = p_wip_id
2043: AND wo1.operation_seq_num > LEAST(p_fm_op,p_to_op)
2044: AND wo1.operation_seq_num <= GREATEST(p_fm_op,p_to_op));
2045: ELSIF(p_fm_step=WIP_CONSTANTS.SCRAP OR p_to_step=WIP_CONSTANTS.SCRAP)THEN
2046: UPDATE WIP_OPERATIONS wo
2047: SET wo.cumulative_scrap_quantity = wo.cumulative_scrap_quantity +
2048: DECODE(p_to_step,
2049: WIP_CONSTANTS.SCRAP,p_qty,
2050: 0) +

Line 2056: FROM WIP_OPERATIONS wo1

2052: WIP_CONSTANTS.SCRAP,-1*p_qty,
2053: 0)
2054: WHERE wo.rowid in
2055: (SELECT wo1.rowid
2056: FROM WIP_OPERATIONS wo1
2057: WHERE wo1.organization_id = p_org_id
2058: AND wo1.wip_entity_id = p_wip_id
2059: AND wo1.operation_seq_num > DECODE(p_fm_step,
2060: WIP_CONSTANTS.SCRAP,p_fm_op,

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

2089:
2090: /*****************************************************************************
2091: * This procedure is equivalent to witpssq_step_qtys_dj in wiltps.ppc
2092: * This procedure is used to check whether the quantity is enough to move or
2093: * not. IF it is enough, update WIP_OPERATIONS.
2094: ****************************************************************************/
2095: PROCEDURE check_qty_dj(p_gib IN OUT NOCOPY group_rec_t,
2096: x_returnStatus OUT NOCOPY VARCHAR2) IS
2097:

Line 2277: FROM wip_operations wop

2273: l_run_qty,
2274: l_tomove_qty,
2275: l_reject_qty,
2276: l_scrap_qty
2277: FROM wip_operations wop
2278: WHERE wop.organization_id = l_dj_txn.org_id
2279: AND wop.wip_entity_id = l_dj_txn.wip_id
2280: AND wop.operation_seq_num = l_dj_txn.fm_op;
2281:

Line 2373: -- update wip_operations for child move txns

2369: l_errMsg := 'wip_movProc_priv.update_wipops failed';
2370: raise fnd_api.g_exc_unexpected_error;
2371: END IF;
2372:
2373: -- update wip_operations for child move txns
2374: update_wo_dj(p_gib => p_gib,
2375: p_fm_op => l_oc_fm_op,
2376: p_fm_step => WIP_CONSTANTS.QUEUE,
2377: p_to_op => l_dj_txn.fm_op,

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

2416: END IF; -- l_propagate_job_change_to_po = WIP_CONSTANTS.YES
2417: END IF; -- l_dj_txn.oc_pri_qty <> 0 and customer have PO FPJ
2418: END IF; -- IF parent_txn
2419:
2420: -- update wip_operations for parent and normal move txns
2421: update_wo_dj(p_gib => p_gib,
2422: p_fm_op => l_dj_txn.fm_op,
2423: p_fm_step => l_dj_txn.fm_step,
2424: p_to_op => l_dj_txn.to_op,

Line 3407: wip_operations wop,

3403: bom_resources br,
3404: cst_activities ca,
3405: wip_operation_resources wor,
3406: wip_discrete_jobs wdj,
3407: wip_operations wop,
3408: wip_move_txn_interface wmti
3409: WHERE wmti.group_id = p_gib.group_id
3410: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3411: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 3619: wip_operations wop,

3615: bom_resources br,
3616: cst_activities ca,
3617: wip_operation_resources wor,
3618: wip_move_txn_allocations wma,
3619: wip_operations wop,
3620: wip_move_txn_interface wmti
3621: WHERE wmti.group_id = p_gib.group_id
3622: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3623: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 3860: wip_operations wop,

3856: bom_resources br,
3857: cst_activities ca,
3858: wip_operation_resources wor,
3859: wip_discrete_jobs wdj,
3860: wip_operations wop,
3861: wip_move_txn_interface wmti
3862: WHERE wmti.group_id = p_gib.group_id
3863: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
3864: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 4071: wip_operations wop,

4067: bom_resources br,
4068: cst_activities ca,
4069: wip_operation_resources wor,
4070: wip_move_txn_allocations wma,
4071: wip_operations wop,
4072: wip_move_txn_interface wmti
4073: WHERE wmti.group_id = p_gib.group_id
4074: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
4075: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 4280: wip_operations wop,

4276: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
4277: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
4278:
4279: FROM wip_operation_resources wor,
4280: wip_operations wop,
4281: wip_move_txn_allocations wma,
4282: wip_cost_txn_interface wci,
4283: wip_move_txn_interface wmti
4284: WHERE wmti.group_id = p_gib.group_id

Line 4694: wip_operations wop,

4690: NULL, -- repetitive_schedule_id
4691: MAX(wdj.project_id),
4692: MAX(wdj.task_id)
4693: FROM bom_departments bd,
4694: wip_operations wop,
4695: wip_operation_resources wor,
4696: wip_discrete_jobs wdj,
4697: wip_move_txn_interface wmti,
4698: wip_requirement_operations WRO

Line 4917: wip_operations wop,

4913: NULL, -- po_line_id
4914: NULL -- repetitive_schedule_id
4915: FROM bom_departments bd,
4916: wip_move_txn_allocations wma,
4917: wip_operations wop,
4918: wip_move_txn_interface wmti,
4919: wip_operation_resources wor
4920: WHERE wmti.group_id = p_gib.group_id
4921: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5153: wip_operations wop,

5149: NULL, -- repetitive_schedule_id
5150: MAX(wdj.project_id),
5151: MAX(wdj.task_id)
5152: FROM bom_departments bd,
5153: wip_operations wop,
5154: wip_operation_resources wor,
5155: wip_discrete_jobs wdj,
5156: wip_move_txn_interface wmti
5157: WHERE wmti.group_id = p_gib.group_id

Line 5369: wip_operations wop,

5365: NULL, -- po_line_id
5366: wma.repetitive_schedule_id
5367: FROM bom_departments bd,
5368: wip_move_txn_allocations wma,
5369: wip_operations wop,
5370: wip_move_txn_interface wmti,
5371: wip_operation_resources wor
5372: WHERE wmti.group_id = p_gib.group_id
5373: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5563: wip_operations wop,

5559: 0, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0),
5560: 1, DECODE(SIGN(MAX(wop.quantity_completed)),1,0,1),
5561: -1, DECODE(SIGN(MAX(wop.quantity_completed)),1,-1,0))
5562: FROM wip_move_txn_allocations wma,
5563: wip_operations wop,
5564: wip_cost_txn_interface wci,
5565: wip_move_txn_interface wmti
5566: WHERE wmti.group_id = p_gib.group_id
5567: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 5709: wip_operations wo,

5705: wmti.organization_id org_id,
5706: wo.operation_seq_num op_seq_num,
5707: wmti.overcompletion_primary_qty oc_qty
5708: FROM wip_move_txn_interface wmti,
5709: wip_operations wo,
5710: wip_operation_resources wor,
5711: wip_discrete_jobs wdj
5712: WHERE wmti.group_id = p_group_id
5713: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5738: wip_operations wo,

5734: wmti.organization_id org_id,
5735: wo.operation_seq_num op_seq_num,
5736: wmti.overcompletion_primary_qty oc_qty
5737: FROM wip_move_txn_interface wmti,
5738: wip_operations wo,
5739: wip_operation_resources wor,
5740: wip_repetitive_schedules wrs
5741: WHERE wmti.group_id = p_group_id
5742: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5937: wip_operations wo1,

5933: fnd_user fu,
5934: bom_departments bd,
5935: hr_organization_information hoi,
5936: wip_discrete_jobs wdj,
5937: wip_operations wo1,
5938: wip_operations wo2
5939: WHERE wmti.group_id = p_gib.group_id
5940: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5941: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 5938: wip_operations wo2

5934: bom_departments bd,
5935: hr_organization_information hoi,
5936: wip_discrete_jobs wdj,
5937: wip_operations wo1,
5938: wip_operations wo2
5939: WHERE wmti.group_id = p_gib.group_id
5940: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
5941: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
5942: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6142: wip_operations wo1,

6138: hr_organization_information hoi,
6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6143: wip_operations wo2,
6144: wip_move_txn_allocations wma,
6145: wip_move_txn_interface wmti
6146: WHERE wmti.group_id = p_gib.group_id

Line 6143: wip_operations wo2,

6139: wip_entities we,
6140: wip_repetitive_schedules wrs,
6141: wip_operation_resources wor,
6142: wip_operations wo1,
6143: wip_operations wo2,
6144: wip_move_txn_allocations wma,
6145: wip_move_txn_interface wmti
6146: WHERE wmti.group_id = p_gib.group_id
6147: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6347: wip_operations wo1,

6343: fnd_user fu,
6344: bom_departments bd,
6345: hr_organization_information hoi,
6346: wip_discrete_jobs wdj,
6347: wip_operations wo1,
6348: wip_operations wo2
6349: WHERE wmti.group_id = p_gib.group_id
6350: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6351: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC

Line 6348: wip_operations wo2

6344: bom_departments bd,
6345: hr_organization_information hoi,
6346: wip_discrete_jobs wdj,
6347: wip_operations wo1,
6348: wip_operations wo2
6349: WHERE wmti.group_id = p_gib.group_id
6350: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)
6351: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6352: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6570: wip_operations wo1,

6566: hr_organization_information hoi,
6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6571: wip_operations wo2,
6572: wip_move_txn_allocations wma,
6573: wip_move_txn_interface wmti
6574: WHERE wmti.group_id = p_gib.group_id

Line 6571: wip_operations wo2,

6567: wip_operation_resources wor,
6568: wip_repetitive_schedules wrs,
6569: wip_entities we,
6570: wip_operations wo1,
6571: wip_operations wo2,
6572: wip_move_txn_allocations wma,
6573: wip_move_txn_interface wmti
6574: WHERE wmti.group_id = p_gib.group_id
6575: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 6753: wip_operations wo,

6749: wor.autocharge_type autocharge_type
6750: FROM bom_resources br,
6751: mtl_units_of_measure muom,
6752: wip_operation_resources wor,
6753: wip_operations wo,
6754: wip_move_txn_interface wmti
6755: WHERE wmti.group_id = p_group_id
6756: AND wmti.process_phase = WIP_CONSTANTS.MOVE_PROC
6757: AND wmti.process_status = WIP_CONSTANTS.RUNNING

Line 6932: * WIP_OPERATIONS

6928:
6929: /*****************************************************************************
6930: * This procedure is equivalent to witpsuc_op_units_complete in wiltps5.ppc
6931: * This procedure is used to update operation unit complete in
6932: * WIP_OPERATIONS
6933: ****************************************************************************/
6934: PROCEDURE update_complete_qty(p_gib IN group_rec_t,
6935: p_txn_id IN NUMBER := NULL,
6936: x_returnStatus OUT NOCOPY VARCHAR2) IS

Line 6961: UPDATE wip_operations wop

6957:
6958: /*------------------------------------------------------------+
6959: | Update quantity_completed
6960: +------------------------------------------------------------*/
6961: UPDATE wip_operations wop
6962: SET (quantity_completed,
6963: last_updated_by,
6964: last_update_date,
6965: last_update_login,

Line 7008: FROM wip_operations wop1,

7004: DECODE(p_gib.request_id,-1,NULL,p_gib.request_id),
7005: DECODE(p_gib.application_id,-1,NULL,p_gib.application_id),
7006: DECODE(p_gib.program_id,-1,NULL,p_gib.program_id),
7007: DECODE(p_gib.request_id,-1,NULL,SYSDATE)-- program_update_date
7008: FROM wip_operations wop1,
7009: wip_move_txn_allocations wma1,
7010: wip_move_txn_interface wmti
7011: WHERE wop1.rowid = wop.rowid
7012: AND wmti.group_id = p_gib.group_id

Line 7056: FROM wip_operations wop2,

7052: AND wmti.fm_intraoperation_step_type > WIP_CONSTANTS.RUN)))
7053: ))
7054: WHERE wop.rowid IN
7055: (SELECT wop2.rowid
7056: FROM wip_operations wop2,
7057: wip_move_txn_allocations wma2,
7058: wip_move_txn_interface wmti
7059: WHERE wop2.organization_id = wmti.organization_id
7060: AND wmti.group_id = p_gib.group_id

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

7103: -- IF debug message level = 2, write statement below to log file
7104: IF (l_logLevel <= wip_constants.full_logging) THEN
7105: fnd_message.set_name('WIP', 'WIP_UPDATED_ROWS');
7106: fnd_message.set_token('ENTITY1', SQL%ROWCOUNT);
7107: fnd_message.set_token('ENTITY2', 'WIP_OPERATIONS');
7108: l_msg := fnd_message.get;
7109: wip_logger.log(p_msg => l_msg,
7110: x_returnStatus => l_returnStatus);
7111: END IF;

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

7555: END snapshot_background;
7556:
7557: /*****************************************************************************
7558: * This procedure will be used to update quantity_completed, and take snapshot
7559: * of wip_operations if applicable(LIFO, FIFO, and average costing)
7560: ****************************************************************************/
7561: PROCEDURE update_wo_and_snapshot(p_gib IN group_rec_t,
7562: x_returnStatus OUT NOCOPY VARCHAR2) IS
7563: CURSOR c_move_rec IS

Line 7979: FROM wip_operations wo

7975: wrs.quantity_completed) -
7976: SUM(NVL(wo.quantity_scrapped, 0))),
7977: 1, WIP_CONSTANTS.RELEASED,
7978: WIP_CONSTANTS.COMP_CHRG)
7979: FROM wip_operations wo
7980: WHERE wo.organization_id = wrs.organization_id
7981: AND wo.repetitive_schedule_id = wrs.repetitive_schedule_id)
7982: WHERE wrs.status_type IN (WIP_CONSTANTS.RELEASED,
7983: WIP_CONSTANTS.COMP_CHRG)

Line 8634: wip_operations wop,

8630: -- material processor need this value to enable quality
8631: wmti.qa_collection_id
8632: FROM wip_move_txn_interface wmti,
8633: mtl_item_locations mil,
8634: wip_operations wop,
8635: mtl_system_items msi,
8636: wip_discrete_jobs wdj
8637: WHERE wmti.group_id = p_gib.group_id
8638: AND TRUNC(wmti.transaction_date) = TRUNC(p_gib.txn_date)

Line 8767: wip_operations wop,

8763: -- populate this value for EZ completion/return because
8764: -- material processor need this value to enable quality
8765: wmti.qa_collection_id
8766: FROM wip_move_txn_interface wmti,
8767: wip_operations wop,
8768: mtl_system_items msi,
8769: wip_repetitive_schedules wrs,
8770: wip_repetitive_items wri
8771: WHERE wmti.group_id = p_gib.group_id

Line 9378: -- Lock record in WIP_OPERATIONS table

9374: p_params => l_params,
9375: x_returnStatus => l_returnStatus);
9376: END IF;
9377:
9378: -- Lock record in WIP_OPERATIONS table
9379: lock_wipops(p_gib => p_gib,
9380: x_returnStatus => x_returnStatus);
9381:
9382: IF(x_returnStatus <> fnd_api.g_ret_sts_success) THEN

Line 9409: -- Lock record in WIP_OPERATIONS table

9405: raise fnd_api.g_exc_unexpected_error;
9406: END IF; -- check return status
9407: END IF; -- check discrete and OSFM jobs
9408:
9409: -- Lock record in WIP_OPERATIONS table
9410: -- Update the WRO quantities for the Overcompletion
9411: update_wro(p_gib => p_gib,
9412: x_returnStatus => x_returnStatus);
9413: