APPS.CSI_DEBUG_PKG dependencies on CSI_TRANSACTIONS

Line 1000: FROM csi_transactions

996: SELECT transaction_id,
997: transaction_date
998: INTO px_mmt_rec.csi_txn_id,
999: px_mmt_rec.csi_txn_date
1000: FROM csi_transactions
1001: WHERE inv_material_transaction_id = px_mmt_rec.mtl_txn_id
1002: AND rownum = 1;
1003: px_mmt_rec.status := 'PROCESSED';
1004: EXCEPTION

Line 1809: FROM csi_transactions

1805: transaction_date,
1806: source_header_ref_id,
1807: source_header_ref,
1808: source_line_ref
1809: FROM csi_transactions
1810: WHERE source_line_ref_id = p_order_line_id;
1811:
1812: CURSOR err_cur(p_order_line_id IN number) IS
1813: SELECT transaction_error_id,

Line 2718: csi_transactions ct,

2714: to_char(ct.source_transaction_date, 'mm/dd/yy hh:mi:ss') source_transaction_date,
2715: ctt.source_transaction_type,
2716: ct.inv_material_transaction_id
2717: FROM csi_item_instances_h ciih,
2718: csi_transactions ct,
2719: csi_txn_types ctt
2720: WHERE ciih.instance_id = p_inst_id
2721: AND ct.transaction_id = ciih.transaction_id
2722: AND ctt.transaction_type_id = ct.transaction_type_id