DBA Data[Home] [Help]

APPS.WIP_MTLPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS

Line 135: from mtl_material_transactions_temp mmtt, mtl_system_items_b msi

131: l_issueRec.rebuildItemID,
132: l_issueRec.rebuildJobName,
133: l_issueRec.rebuildActivityID,
134: l_issueRec.rebuildSerialNumber
135: from mtl_material_transactions_temp mmtt, mtl_system_items_b msi
136: where transaction_temp_id = p_txnTmpID
137: and mmtt.inventory_item_id = msi.inventory_item_id
138: and mmtt.organization_id = msi.organization_id
139: and nvl(flow_schedule, 'N') <> 'Y';

Line 743: from mtl_material_transactions_temp

739: elsif(p_issueRec.cplTxnID is not null) then
740: --the completion transaction could either be in mmtt or mmt...
741: select count(*)
742: into l_mmttCount
743: from mtl_material_transactions_temp
744: where completion_transaction_id = p_issueRec.cplTxnID
745: and transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action);
746:
747: if(l_mmttCount > 0) then

Line 755: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows

751: bulk collect into x_schedTbl, x_qtyTbl
752: from wip_repetitive_schedules wrs,
753: wip_requirement_operations wro,
754: mtl_material_txn_allocations mmta,
755: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
756: where mmta.transaction_id = mmtt.material_allocation_temp_id
757: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
758: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
759: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 783: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows

779: bulk collect into x_schedTbl, x_qtyTbl
780: from wip_repetitive_schedules wrs,
781: wip_requirement_operations wro,
782: wip_mtl_allocations_temp wmat,
783: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
784: where wmat.transaction_temp_id = mmtt.transaction_temp_id
785: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
786: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
787: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 807: mtl_material_transactions_temp mmtt

803: bulk collect into x_schedTbl, x_qtyTbl
804: from wip_repetitive_schedules wrs,
805: wip_requirement_operations wro,
806: mtl_material_txn_allocations mmta,
807: mtl_material_transactions_temp mmtt
808: where mmta.transaction_id = mmtt.material_allocation_temp_id
809: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
810: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
811: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 834: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows

830: bulk collect into x_schedTbl, x_qtyTbl
831: from wip_repetitive_schedules wrs,
832: wip_requirement_operations wro,
833: wip_mtl_allocations_temp wmat,
834: mtl_material_transactions_temp mmtt --the MMTT row(s) are the assy rows
835: where wmat.transaction_temp_id = mmtt.transaction_temp_id
836: and mmtt.completion_transaction_id = p_issueRec.cplTxnID
837: and mmtt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
838: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 862: mtl_material_transactions mmt

858: bulk collect into x_schedTbl, x_qtyTbl
859: from wip_repetitive_schedules wrs,
860: wip_requirement_operations wro,
861: mtl_material_txn_allocations mmta,
862: mtl_material_transactions mmt
863: where mmta.transaction_id = mmt.transaction_id
864: and mmt.completion_transaction_id = p_issueRec.cplTxnID
865: and mmt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
866: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 884: mtl_material_transactions mmt

880: bulk collect into x_schedTbl, x_qtyTbl
881: from wip_repetitive_schedules wrs,
882: wip_requirement_operations wro,
883: mtl_material_txn_allocations mmta,
884: mtl_material_transactions mmt
885: where mmta.transaction_id = mmt.transaction_id
886: and mmt.completion_transaction_id = p_issueRec.cplTxnID
887: and mmt.transaction_action_id in (wip_constants.cplassy_action, wip_constants.retassy_action)
888: and wro.wip_entity_id = p_issueRec.wipEntityID

Line 953: update mtl_material_transactions_temp

949: raise fnd_api.g_exc_unexpected_error;
950: end if;
951:
952: if(p_issueRec.mtlTxnID is null) then
953: update mtl_material_transactions_temp
954: set material_allocation_temp_id = mtl_material_transactions_s.nextval
955: where transaction_temp_id = p_issueRec.txnTmpID returning material_allocation_temp_id into p_issueRec.mtlTxnID;
956: end if;
957:

Line 954: set material_allocation_temp_id = mtl_material_transactions_s.nextval

950: end if;
951:
952: if(p_issueRec.mtlTxnID is null) then
953: update mtl_material_transactions_temp
954: set material_allocation_temp_id = mtl_material_transactions_s.nextval
955: where transaction_temp_id = p_issueRec.txnTmpID returning material_allocation_temp_id into p_issueRec.mtlTxnID;
956: end if;
957:
958: --if over-issuing or returning, apply excess qty to the last schedule

Line 1167: update mtl_material_transactions_temp

1163: wip_logger.log('writeError: tempID is ' || p_txnTmpID, l_returnStatus);
1164: wip_logger.log('writeError: errCode is ' ||l_errCode, l_returnStatus);
1165: wip_logger.log('writeError: errExpl is ' ||l_errExpl, l_returnStatus);
1166: end if;
1167: update mtl_material_transactions_temp
1168: set error_code = substr(l_errCode, 1, 240),
1169: error_explanation = substr(l_errExpl, 1, 240),
1170: process_flag = 'E'
1171: where transaction_temp_id = p_txnTmpID;