APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_TRANSACTIONS

Line 253: csi_transactions ct,

249: SELECT pa.ORG_ID
250: INTO l_txn_ou_context
251: FROM csi_item_instances_h ciih,
252: csi_item_instances cii,
253: csi_transactions ct,
254: pa_projects_all pa
255: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id
256: AND ciih.instance_id = p_asset_attrib_rec.instance_id
257: AND cii.instance_id = p_asset_attrib_rec.instance_id

Line 844: csi_transactions ct

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
848: AND ct.transaction_type_id = 105 -- rec in to project

Line 853: csi_transactions ct

849: UNION
850: SELECT pda.variance_account_id
851: FROM po_distributions_all pda,
852: ap_invoice_distributions_all aida ,
853: csi_transactions ct
854: WHERE pda.po_distribution_id = aida.po_distribution_id
855: AND aida.invoice_distribution_id = ct.source_dist_ref_id2
856: AND ct.transaction_id = c_transaction_id
857: AND ct.transaction_type_id = 102; -- ap ipv

Line 901: FROM csi_transactions

897: */
898:
899: CURSOR src_mv_txn_cur (c_txn_id IN NUMBER) IS
900: SELECT NVL(source_dist_ref_id2,transaction_id)
901: FROM csi_transactions
902: WHERE transaction_id = c_txn_id ;
903:
904: CURSOR asset_acct_cur (c_book_type_code VARCHAR2 , c_category_id IN NUMBER) IS
905: SELECT asset_clearing_account_ccid

Line 932: FROM csi_transactions

928: source_dist_ref_id1
929: INTO l_csi_txn_type_id,
930: l_mtl_txn_id,
931: l_po_distribution_id
932: FROM csi_transactions
933: WHERE transaction_id = p_asset_attrib_rec.transaction_id;
934:
935: get_txn_class (
936: p_asset_attrib_rec => p_asset_attrib_rec ,

Line 2063: ,csi_transactions ct1

2059: IS
2060: SELECT ct1.transaction_id,
2061: ct1.transaction_date
2062: FROM csi_item_instances_h ciih1
2063: ,csi_transactions ct1
2064: ,csi_txn_types ctt
2065: WHERE ct1.transaction_id = ciih1.transaction_id
2066: AND ct1.transaction_type_id = ctt.transaction_type_id
2067: AND ct1.transaction_id <> p_asset_attrib_rec.transaction_id

Line 2075: csi_transactions ct

2071: 'ISO_SHIPMENT')
2072: AND ciih1.instance_id IN (
2073: SELECT ciih.instance_id
2074: FROM csi_item_instances_h ciih,
2075: csi_transactions ct
2076: WHERE ct.transaction_id = p_asset_attrib_rec.transaction_id
2077: AND ciih.transaction_id = ct.transaction_id)
2078: AND ct1.transaction_status_code = 'PENDING' ;
2079:

Line 2083: FROM csi_transactions ct

2079:
2080: /*CURSOR csi_txn_date_cur
2081: IS
2082: SELECT ct.transaction_date
2083: FROM csi_transactions ct
2084: WHERE ct.transaction_id = p_transaction_id ;*/
2085:
2086: l_transaction_id NUMBER ;
2087: l_current_txn_date DATE ;