APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_TRANSACTION_LINES

Line 170: FROM csi_t_transaction_lines

166:
167: BEGIN
168: SELECT transaction_line_id
169: INTO l_c_tl_rec.transaction_line_id
170: FROM csi_t_transaction_lines
171: WHERE source_transaction_table = l_c_tl_rec.source_transaction_table
172: AND source_transaction_id = l_c_tl_rec.source_transaction_id
173: AND source_transaction_type_id = l_c_tl_rec.source_transaction_type_id;
174: EXCEPTION

Line 393: FROM csi_t_transaction_lines

389: BEGIN
390:
391: SELECT transaction_line_id
392: INTO l_transaction_line_id
393: FROM csi_t_transaction_lines
394: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
395: AND source_transaction_id = p_order_line_rec.order_line_id;
396:
397: SELECT sum(abs(quantity))

Line 780: FROM csi_t_transaction_lines

776:
777: BEGIN
778: SELECT transaction_line_id
779: INTO l_trx_line_id
780: FROM csi_t_transaction_lines
781: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
782: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
783:
784: EXCEPTION

Line 937: FROM csi_t_transaction_lines

933: debug(' Yes it is.');
934: BEGIN
935: SELECT transaction_line_id
936: INTO l_trx_line_id
937: FROM csi_t_transaction_lines
938: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
939: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
940: EXCEPTION
941: WHEN no_data_found THEN

Line 1152: FROM csi_t_transaction_lines

1148: UPDATE csi_t_txn_line_details
1149: SET processing_status = 'IN_PROCESS'
1150: WHERE transaction_line_id IN (
1151: SELECT transaction_line_id
1152: FROM csi_t_transaction_lines
1153: WHERE source_transaction_table = l_literal2
1154: AND source_transaction_id = l_order_line_rec.order_line_id)
1155: AND source_transaction_flag = 'N'
1156: AND processing_status <> l_literal1;

Line 2761: FROM csi_t_transaction_lines

2757: l_txn_line_rec.source_transaction_id := p_order_line_rec.order_line_id;
2758: BEGIN
2759: SELECT transaction_line_id
2760: INTO l_txn_line_rec.transaction_line_id
2761: FROM csi_t_transaction_lines
2762: WHERE source_transaction_id = l_txn_line_rec.source_transaction_id
2763: AND source_transaction_table = l_txn_line_rec.source_transaction_table;
2764: EXCEPTION
2765: WHEN no_data_found THEN

Line 4757: FROM csi_t_transaction_lines b

4753: WHERE a.processing_status <> l_literal1
4754: AND a.source_transaction_flag = 'Y'
4755: AND a.inventory_item_id = p_order_line_rec.inv_item_id
4756: AND a.transaction_line_id in (SELECT transaction_line_id
4757: FROM csi_t_transaction_lines b
4758: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug bug 4311676
4759: b.source_transaction_id = p_order_line_rec.order_line_id
4760: AND b.source_transaction_table = l_literal2 );
4761:

Line 4762: UPDATE csi_t_transaction_lines

4758: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug bug 4311676
4759: b.source_transaction_id = p_order_line_rec.order_line_id
4760: AND b.source_transaction_table = l_literal2 );
4761:
4762: UPDATE csi_t_transaction_lines
4763: SET processing_status = 'PROCESSED'
4764: WHERE source_transaction_id = p_order_line_rec.order_line_id;
4765:
4766: DELETE FROM csi_t_txn_line_details

Line 7208: UPDATE CSI_T_TRANSACTION_LINES

7204: END IF;
7205: --
7206: debug('Updating CONFIGURATOR Created Transaction Details...');
7207: --
7208: UPDATE CSI_T_TRANSACTION_LINES
7209: set PROCESSING_STATUS = 'PROCESSED'
7210: where transaction_line_id in
7211: ( select transaction_line_id
7212: from CSI_T_TXN_LINE_DETAILS

Line 7960: FROM csi_t_transaction_lines

7956: BEGIN
7957:
7958: SELECT transaction_line_id
7959: INTO l_trx_line_id
7960: FROM csi_t_transaction_lines
7961: WHERE source_transaction_id = x_cre_txn_line_rec.source_transaction_id
7962: and source_transaction_table = x_cre_txn_line_rec.source_transaction_table
7963: and source_transaction_type_id = x_cre_txn_line_rec.source_transaction_type_id;
7964: