APPS.RCV_ACCRUALUTILITIES_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 439: FROM mtl_material_transactions MMT

435:
436: l_stmt_num := 80;
437: SELECT (MMT.transaction_cost * rec_txn.source_doc_quantity)
438: INTO l_txn_price
439: FROM mtl_material_transactions MMT
440: WHERE MMT.rcv_transaction_id = rec_txn.transaction_id
441: AND MMT.organization_id = rec_txn.organization_id;
442:
443:

Line 523: from mtl_material_transactions MMT

519: /* In Non GLobal Procurement after patchet J delivery might be in MMT,WT,WCTI and not in RAE*/
520: l_stmt_num := 96 ;
521: Select count(*),sum((MMT.transaction_cost * rec_txn.source_doc_quantity))
522: into l_mmt_count,l_txn_price
523: from mtl_material_transactions MMT
524: where MMT.rcv_transaction_id = rec_txn.transaction_id
525: AND MMT.organization_id = rec_txn.organization_id;
526:
527: IF(l_mmt_count = 0) then

Line 1186: from mtl_material_transactions mmt,

1182: if (l_destTypeCode = 'INVENTORY') then
1183: l_stmt_num := 40;
1184: select sum(nvl(mta.base_transaction_value, 0))
1185: into l_encReversalAmt
1186: from mtl_material_transactions mmt,
1187: mtl_transaction_accounts mta,
1188: rcv_transactions rt
1189: where rt.po_distribution_id = p_po_distribution_id
1190: and fnd_date.date_to_canonical(rt.transaction_date)