DBA Data[Home] [Help]

APPS.RCV_ACCRUALUTILITIES_GRP dependencies on MTL_MATERIAL_TRANSACTIONS

Line 431: FROM mtl_material_transactions MMT

427:
428: l_stmt_num := 80;
429: SELECT (MMT.transaction_cost * rec_txn.source_doc_quantity)
430: INTO l_txn_price
431: FROM mtl_material_transactions MMT
432: WHERE MMT.rcv_transaction_id = rec_txn.transaction_id
433: AND MMT.organization_id = rec_txn.organization_id;
434:
435:

Line 1081: from mtl_material_transactions mmt,

1077: if (l_destTypeCode = 'INVENTORY') then
1078: l_stmt_num := 40;
1079: select sum(nvl(mta.base_transaction_value, 0))
1080: into l_encReversalAmt
1081: from mtl_material_transactions mmt,
1082: mtl_transaction_accounts mta,
1083: rcv_transactions rt
1084: where rt.po_distribution_id = p_po_distribution_id
1085: and fnd_date.date_to_canonical(rt.transaction_date)