DBA Data[Home] [Help]

APPS.CSE_ASSET_UTIL_PKG dependencies on RCV_TRANSACTIONS

Line 316: FROM rcv_transactions rt,

312: BEGIN
313: DEBUG('inside '|| l_api_name || 'Receipt item into project');
314: SELECT cod.operating_unit
315: INTO l_txn_ou_context
316: FROM rcv_transactions rt,
317: csi_inst_txn_details_v citdv,
318: org_organization_definitions cod
319: WHERE citdv.transaction_id = p_asset_attrib_rec.transaction_id
320: AND citdv.source_transaction_type = 'PO_RECEIPT_INTO_PROJECT'

Line 889: rcv_transactions rt,

885:
886: CURSOR payables_ccid_cur (c_transaction_id IN NUMBER,c_instance_id IN NUMBER) IS
887: SELECT pda.code_combination_id
888: FROM po_distributions_all pda,
889: rcv_transactions rt,
890: csi_transactions ct
891: WHERE pda.po_distribution_id = rt.po_distribution_id
892: AND rt.transaction_id = ct.source_dist_ref_id2
893: AND ct.transaction_id = c_transaction_id

Line 2579: FROM rcv_transactions rt

2575: IS
2576: SELECT pla.unit_price ---Unit Price for ONE UOM
2577: ,pla_muom.uom_code pla_uom_code
2578: ,rcv_muom.uom_code primary_uom_code
2579: FROM rcv_transactions rt
2580: ,po_lines_all pla
2581: ,mtl_units_of_measure pla_muom
2582: ,mtl_units_of_measure rcv_muom
2583: WHERE rt.transaction_id = p_source_txn_id