APPS.WIP_CPLPROC_PRIV dependencies on WIP_MTL_ALLOCATIONS_TEMP

Line 560: wip_mtl_allocations_temp wmat

556: rowidtochar(wrs.rowid),
557: rowidtochar(wo.rowid)
558: from wip_operations wo,
559: wip_repetitive_schedules wrs,
560: wip_mtl_allocations_temp wmat
561: where wrs.wip_entity_id = p_cplRec.wipEntityID
562: and wrs.line_id = p_cplRec.repLineID
563: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
564: and wrs.repetitive_schedule_id = wo.repetitive_schedule_id (+)

Line 726: from wip_mtl_allocations_temp wmat

722: fnd_global.conc_request_id,
723: fnd_global.prog_appl_id,
724: fnd_global.conc_program_id,
725: wmat.transaction_date
726: from wip_mtl_allocations_temp wmat
727: where wmat.transaction_temp_id = p_txnTmpID;
728:
729: if (l_logLevel <= wip_constants.full_logging) then
730: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows into MMTA', l_returnStatus);

Line 732: delete wip_mtl_allocations_temp

728:
729: if (l_logLevel <= wip_constants.full_logging) then
730: wip_logger.log('inserted ' || SQL%ROWCOUNT || ' rows into MMTA', l_returnStatus);
731: end if;
732: delete wip_mtl_allocations_temp
733: where transaction_temp_id = p_txnTmpID;
734:
735: if (l_logLevel <= wip_constants.full_logging) then
736: wip_logger.log('deleted ' || SQL%ROWCOUNT || ' rows from WMAT', l_returnStatus);

Line 958: wip_mtl_allocations_temp wmat

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

Line 983: wip_mtl_allocations_temp wmat

979: wrs.bom_revision bomRev,
980: wrs.quantity_completed availQty,
981: nvl(sum(wmat.primary_quantity), 0) tempQty
982: from wip_repetitive_schedules wrs,
983: wip_mtl_allocations_temp wmat
984: where wrs.wip_entity_id = v_wipEntityID
985: and wrs.line_id = v_repLineID
986: and wrs.date_released < v_txnDate
987: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)

Line 1212: insert into wip_mtl_allocations_temp

1208: if(l_schedQty <> 0) then
1209: if (l_logLevel <= wip_constants.full_logging) then
1210: wip_logger.log('inserting into temp table; sched:' || l_schedRecTbl.repSchedID(j) || '; qty:' || l_schedQty, l_returnStatus);
1211: end if;
1212: insert into wip_mtl_allocations_temp
1213: (transaction_temp_id,
1214: completion_transaction_id,
1215: repetitive_schedule_id,
1216: organization_id,

Line 1270: update wip_mtl_allocations_temp

1266: wip_logger.log('schedID' || l_lastSchedID, l_returnStatus);
1267: end if;
1268:
1269: --in below stmt, transaction_quantity = old_qty + (conversion ratio * new primary_qty)
1270: update wip_mtl_allocations_temp
1271: set transaction_quantity = transaction_quantity +
1272: (transaction_quantity/primary_quantity * l_remainingQty),
1273: primary_quantity = primary_quantity + l_remainingQty
1274: where transaction_temp_id = l_txnRecTbl.txnID(i)

Line 1302: insert into wip_mtl_allocations_temp

1298: /* Fixed bug 3698513. Completion_transaction_id is a not null column
1299: * , so we have to insert a value into this column. This bug only
1300: * occur when overcompletion and available quantity is zero.
1301: */
1302: insert into wip_mtl_allocations_temp
1303: (transaction_temp_id,
1304: completion_transaction_id,
1305: repetitive_schedule_id,
1306: organization_id,

Line 1383: wip_mtl_allocations_temp wmat

1379: ((wrs.daily_production_rate * wrs.processing_work_days) - wrs.quantity_completed) startQty,
1380: wrs.quantity_completed cplQty,
1381: sum(wmat.primary_quantity) tempQty
1382: from wip_repetitive_schedules wrs,
1383: wip_mtl_allocations_temp wmat
1384: where wrs.wip_entity_id = p_wipEntityID
1385: and wrs.line_id = p_repLineID
1386: and wrs.status_type in (wip_constants.released, wip_constants.comp_chrg)
1387: and wrs.repetitive_schedule_id = wmat.repetitive_schedule_id (+)

Line 1446: insert into wip_mtl_allocations_temp

1442: wip_logger.log('returning to schedule' || l_schedID, l_returnStatus);
1443: end if;
1444:
1445: if(p_tblName = wip_constants.MMTT_TBL) then
1446: insert into wip_mtl_allocations_temp
1447: (transaction_temp_id,
1448: repetitive_schedule_id,
1449: organization_id,
1450: last_update_date,

Line 1482: insert into wip_mtl_allocations_temp

1478: where mmtt.transaction_header_id = p_txnHdrID
1479: and mmtt.completion_transaction_id = p_cplTxnID
1480: and mmtt.transaction_action_id = wip_constants.retassy_action;
1481: elsif(p_tblName = wip_constants.MTI_TBL) then
1482: insert into wip_mtl_allocations_temp
1483: (transaction_temp_id,
1484: repetitive_schedule_id,
1485: organization_id,
1486: last_update_date,