APPS.WIP_CPLPROC_PRIV dependencies on WIP_MTL_ALLOCATIONS_TEMP

Line 535: wip_mtl_allocations_temp wmat

531: rowidtochar(wrs.rowid),
532: rowidtochar(wo.rowid)
533: from wip_operations wo,
534: wip_repetitive_schedules wrs,
535: wip_mtl_allocations_temp wmat
536: where wrs.wip_entity_id = p_cplRec.wipEntityID
537: and wrs.line_id = p_cplRec.repLineID
538: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
539: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)

Line 701: from wip_mtl_allocations_temp wmat

697: fnd_global.conc_request_id,
698: fnd_global.prog_appl_id,
699: fnd_global.conc_program_id,
700: wmat.transaction_date
701: from wip_mtl_allocations_temp wmat
702: where wmat.transaction_temp_id = p_txnTmpID;
703:
704: if (l_logLevel <= wip_constants.full_logging) then
705: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows into MMTA', l_returnStatus);

Line 707: delete wip_mtl_allocations_temp

703:
704: if (l_logLevel <= wip_constants.full_logging) then
705: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows into MMTA', l_returnStatus);
706: end if;
707: delete wip_mtl_allocations_temp
708: where transaction_temp_id = p_txnTmpID;
709:
710: if (l_logLevel <= wip_constants.full_logging) then
711: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' rows from WMAT', l_returnStatus);

Line 932: wip_mtl_allocations_temp wmat

928: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed)) availQty,
929: nvl(sum(wmat.primary_quantity), 0) tempQty
930: from wip_operations wo,
931: wip_repetitive_schedules wrs,
932: wip_mtl_allocations_temp wmat
933: where wrs.wip_entity_id = v_wipEntityID
934: and wrs.line_id = v_repLineID
935: and wrs.date_released < v_txnDate
936: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

Line 957: wip_mtl_allocations_temp wmat

953: wrs.bom_revision bomRev,
954: wrs.quantity_completed availQty,
955: nvl(sum(wmat.primary_quantity), 0) tempQty
956: from wip_repetitive_schedules wrs,
957: wip_mtl_allocations_temp wmat
958: where wrs.wip_entity_id = v_wipEntityID
959: and wrs.line_id = v_repLineID
960: and wrs.date_released < v_txnDate
961: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

Line 1186: insert into wip_mtl_allocations_temp

1182: if(l_schedQty <> 0) then
1183: if (l_logLevel <= wip_constants.full_logging) then
1184: wip_logger.log('inserting into temp table; sched:' || l_schedRecTbl.repSchedID(j) || '; qty:' || l_schedQty, l_returnStatus);
1185: end if;
1186: insert into wip_mtl_allocations_temp
1187: (transaction_temp_id,
1188: completion_transaction_id,
1189: repetitive_schedule_id,
1190: organization_id,

Line 1244: update wip_mtl_allocations_temp

1240: wip_logger.log('schedID' || l_lastSchedID, l_returnStatus);
1241: end if;
1242:
1243: --in below stmt, transaction_quantity = old_qty + (conversion ratio * new primary_qty)
1244: update wip_mtl_allocations_temp
1245: set transaction_quantity = transaction_quantity +
1246: (transaction_quantity/primary_quantity * l_remainingQty),
1247: primary_quantity = primary_quantity + l_remainingQty
1248: where transaction_temp_id = l_txnRecTbl.txnID(i)

Line 1276: insert into wip_mtl_allocations_temp

1272: /* Fixed bug 3698513. Completion_transaction_id is a not null column
1273: * , so we have to insert a value into this column. This bug only
1274: * occur when overcompletion and available quantity is zero.
1275: */
1276: insert into wip_mtl_allocations_temp
1277: (transaction_temp_id,
1278: completion_transaction_id,
1279: repetitive_schedule_id,
1280: organization_id,

Line 1357: wip_mtl_allocations_temp wmat

1353: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) startQty,
1354: wrs.quantity_completed cplQty,
1355: sum(wmat.primary_quantity) tempQty
1356: from wip_repetitive_schedules wrs,
1357: wip_mtl_allocations_temp wmat
1358: where wrs.wip_entity_id = p_wipEntityID
1359: and wrs.line_id = p_repLineID
1360: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
1361: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id (+)

Line 1420: insert into wip_mtl_allocations_temp

1416: wip_logger.log('returning to schedule' || l_schedID, l_returnStatus);
1417: end if;
1418:
1419: if(p_tblName = wip_constants.MMTT_TBL) then
1420: insert into wip_mtl_allocations_temp
1421: (transaction_temp_id,
1422: repetitive_schedule_id,
1423: organization_id,
1424: last_update_date,

Line 1456: insert into wip_mtl_allocations_temp

1452: where mmtt.transaction_header_id = p_txnHdrID
1453: and mmtt.completion_transaction_id = p_cplTxnID
1454: and mmtt.transaction_action_id = wip_constants.retassy_action;
1455: elsif(p_tblName = wip_constants.MTI_TBL) then
1456: insert into wip_mtl_allocations_temp
1457: (transaction_temp_id,
1458: repetitive_schedule_id,
1459: organization_id,
1460: last_update_date,