APPS.CSE_ASSET_UTIL_PKG dependencies on CSI_TRANSACTIONS

Line 297: csi_transactions ct,

293: SELECT pa.ORG_ID
294: INTO l_txn_ou_context
295: FROM csi_item_instances_h ciih,
296: csi_item_instances cii,
297: csi_transactions ct,
298: pa_projects_all pa
299: WHERE ciih.transaction_id = p_asset_attrib_rec.transaction_id
300: AND ciih.instance_id = p_asset_attrib_rec.instance_id
301: AND cii.instance_id = p_asset_attrib_rec.instance_id

Line 890: csi_transactions ct

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

Line 899: csi_transactions ct

895: UNION
896: SELECT pda.variance_account_id
897: FROM po_distributions_all pda,
898: ap_invoice_distributions_all aida ,
899: csi_transactions ct
900: WHERE pda.po_distribution_id = aida.po_distribution_id
901: AND aida.invoice_distribution_id = ct.source_dist_ref_id2
902: AND ct.transaction_id = c_transaction_id
903: AND ct.transaction_type_id = 102; -- ap ipv

Line 947: FROM csi_transactions

943: */
944:
945: CURSOR src_mv_txn_cur (c_txn_id IN NUMBER) IS
946: SELECT NVL(source_dist_ref_id2,transaction_id)
947: FROM csi_transactions
948: WHERE transaction_id = c_txn_id ;
949:
950: CURSOR asset_acct_cur (c_book_type_code VARCHAR2 , c_category_id IN NUMBER) IS
951: SELECT asset_clearing_account_ccid

Line 992: FROM csi_transactions

988: INTO l_csi_txn_type_id,
989: l_mtl_txn_id,
990: l_po_distribution_id,
991: l_line_id
992: FROM csi_transactions
993: WHERE transaction_id = p_asset_attrib_rec.transaction_id;
994:
995: get_txn_class (
996: p_asset_attrib_rec => p_asset_attrib_rec ,

Line 1746: FROM csi_transactions

1742:
1743: --Added for ER#16265912
1744: SELECT source_line_ref_id
1745: INTO l_line_id
1746: FROM csi_transactions
1747: WHERE transaction_id = p_asset_attrib_rec.transaction_id;
1748:
1749: BEGIN
1750: SELECT 'Y'

Line 2327: ,csi_transactions ct1

2323: IS
2324: SELECT ct1.transaction_id,
2325: ct1.transaction_date
2326: FROM csi_item_instances_h ciih1
2327: ,csi_transactions ct1
2328: ,csi_txn_types ctt
2329: WHERE ct1.transaction_id = ciih1.transaction_id
2330: AND ct1.transaction_type_id = ctt.transaction_type_id
2331: AND ct1.transaction_id <> p_asset_attrib_rec.transaction_id

Line 2339: csi_transactions ct

2335: 'ISO_SHIPMENT')
2336: AND ciih1.instance_id IN (
2337: SELECT ciih.instance_id
2338: FROM csi_item_instances_h ciih,
2339: csi_transactions ct
2340: WHERE ct.transaction_id = p_asset_attrib_rec.transaction_id
2341: AND ciih.transaction_id = ct.transaction_id)
2342: AND ct1.transaction_status_code = 'PENDING' ;
2343:

Line 2347: FROM csi_transactions ct

2343:
2344: /*CURSOR csi_txn_date_cur
2345: IS
2346: SELECT ct.transaction_date
2347: FROM csi_transactions ct
2348: WHERE ct.transaction_id = p_transaction_id ;*/
2349:
2350: l_transaction_id NUMBER ;
2351: l_current_txn_date DATE ;