DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on RCV_TRANSACTIONS

Line 272: FROM rcv_transactions rt,

268: BEGIN
269: DEBUG('inside '|| l_api_name || 'Receipt item into project');
270: SELECT cod.operating_unit
271: INTO l_txn_ou_context
272: FROM rcv_transactions rt,
273: csi_inst_txn_details_v citdv,
274: org_organization_definitions cod
275: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
276: AND citdv.source_transaction_type = 'PO_RECEIPT_INTO_PROJECT'

Line 843: rcv_transactions rt,

839:
840: CURSOR payables_ccid_cur (c_transaction_id IN NUMBER,c_instance_id IN NUMBER) IS
841: SELECT pda.code_combination_id
842: FROM po_distributions_all pda,
843: rcv_transactions rt,
844: csi_transactions ct
845: WHERE pda.po_distribution_id = rt.po_distribution_id
846: AND rt.transaction_id = ct.source_dist_ref_id2
847: AND ct.transaction_id = c_transaction_id

Line 2316: FROM rcv_transactions rt

2312: IS
2313: SELECT pla.unit_price ---Unit Price for ONE UOM
2314: ,pla_muom.uom_code pla_uom_code
2315: ,rcv_muom.uom_code primary_uom_code
2316: FROM rcv_transactions rt
2317: ,po_lines_all pla
2318: ,mtl_units_of_measure pla_muom
2319: ,mtl_units_of_measure rcv_muom
2320: WHERE rt.transaction_id = p_source_txn_id