APPS.WIP_CPLPROC_PRIV dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 122: from mtl_material_transactions_temp

118: l_cplRec.lpnID,
119: l_cplRec.txnMode,
120: l_cplRec.movTxnID,
121: l_cplRec.mtlAlcTmpID
122: from mtl_material_transactions_temp
123: where transaction_temp_id = p_txnTmpID;
124:
125: if(l_cplRec.qaCollectionID is not null) then
126: qa_result_grp.enable(p_api_version => 1.0,

Line 141: update mtl_material_transactions_temp

137:
138: if(nvl(l_cplRec.overCplPriQty, 0) <> 0) then
139: --ensure the overcompletion txn id is populated
140: if(l_cplRec.overCplTxnID is null) then
141: update mtl_material_transactions_temp
142: set overcompletion_transaction_id = wip_transactions_s.nextval
143: where transaction_temp_id = p_txnTmpID returning overcompletion_transaction_id into l_cplRec.overCplTxnID;
144:
145: end if;

Line 980: from mtl_material_transactions_temp

976: primary_quantity priQty,
977: transaction_quantity txnQty,
978: overcompletion_primary_qty,
979: organization_id
980: from mtl_material_transactions_temp
981: where completion_transaction_id = p_cplTxnID
982: and transaction_header_id = p_txnHdrID
983: and transaction_source_id = p_wipEntityID
984: and transaction_source_type_id = 5

Line 1451: from mtl_material_transactions_temp mmtt

1447: sysdate,
1448: mmtt.transaction_quantity,
1449: mmtt.primary_quantity,
1450: mmtt.transaction_date
1451: from mtl_material_transactions_temp mmtt
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

Line 1680: FROM mtl_material_transactions_temp

1676: revision,
1677: overcompletion_primary_qty oc_primary_qty,
1678: last_updated_by,
1679: created_by
1680: FROM mtl_material_transactions_temp
1681: WHERE transaction_temp_id = p_interface_id;
1682:
1683:
1684: l_cmp_txn c_cmp_txn%ROWTYPE;