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 1006: from mtl_material_transactions_temp

1002: primary_quantity priQty,
1003: transaction_quantity txnQty,
1004: overcompletion_primary_qty,
1005: organization_id
1006: from mtl_material_transactions_temp
1007: where completion_transaction_id = p_cplTxnID
1008: and transaction_header_id = p_txnHdrID
1009: and transaction_source_id = p_wipEntityID
1010: and transaction_source_type_id = 5

Line 1477: from mtl_material_transactions_temp mmtt

1473: sysdate,
1474: mmtt.transaction_quantity,
1475: mmtt.primary_quantity,
1476: mmtt.transaction_date
1477: from mtl_material_transactions_temp mmtt
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

Line 1706: FROM mtl_material_transactions_temp

1702: revision,
1703: overcompletion_primary_qty oc_primary_qty,
1704: last_updated_by,
1705: created_by
1706: FROM mtl_material_transactions_temp
1707: WHERE transaction_temp_id = p_interface_id;
1708:
1709:
1710: l_cmp_txn c_cmp_txn%ROWTYPE;