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 837: FROM csi_t_transaction_lines

833:
834: BEGIN
835: SELECT transaction_line_id
836: INTO l_trx_line_id
837: FROM csi_t_transaction_lines
838: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
839: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
840:
841: EXCEPTION

Line 994: FROM csi_t_transaction_lines

990: debug(' Yes it is.');
991: BEGIN
992: SELECT transaction_line_id
993: INTO l_trx_line_id
994: FROM csi_t_transaction_lines
995: WHERE source_transaction_id = l_copy_txn_line_rec.source_transaction_id
996: AND source_transaction_table = l_copy_txn_line_rec.source_transaction_table;
997: EXCEPTION
998: WHEN no_data_found THEN

Line 1209: FROM csi_t_transaction_lines

1205: UPDATE csi_t_txn_line_details
1206: SET processing_status = 'IN_PROCESS'
1207: WHERE transaction_line_id IN (
1208: SELECT transaction_line_id
1209: FROM csi_t_transaction_lines
1210: WHERE source_transaction_table = l_literal2
1211: AND source_transaction_id = l_order_line_rec.order_line_id)
1212: AND source_transaction_flag = 'N'
1213: AND processing_status <> l_literal1;

Line 2820: FROM csi_t_transaction_lines

2816: l_txn_line_rec.source_transaction_id := p_order_line_rec.order_line_id;
2817: BEGIN
2818: SELECT transaction_line_id
2819: INTO l_txn_line_rec.transaction_line_id
2820: FROM csi_t_transaction_lines
2821: WHERE source_transaction_id = l_txn_line_rec.source_transaction_id
2822: AND source_transaction_table = l_txn_line_rec.source_transaction_table;
2823: EXCEPTION
2824: WHEN no_data_found THEN

Line 4836: FROM csi_t_transaction_lines b

4832: WHERE a.processing_status <> l_literal1
4833: AND a.source_transaction_flag = 'Y'
4834: AND a.inventory_item_id = p_order_line_rec.inv_item_id
4835: AND a.transaction_line_id in (SELECT transaction_line_id
4836: FROM csi_t_transaction_lines b
4837: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug bug 4311676
4838: b.source_transaction_id = p_order_line_rec.order_line_id
4839: AND b.source_transaction_table = l_literal2 );
4840:

Line 4841: UPDATE csi_t_transaction_lines

4837: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug bug 4311676
4838: b.source_transaction_id = p_order_line_rec.order_line_id
4839: AND b.source_transaction_table = l_literal2 );
4840:
4841: UPDATE csi_t_transaction_lines
4842: SET processing_status = 'PROCESSED'
4843: WHERE source_transaction_id = p_order_line_rec.order_line_id;
4844:
4845: DELETE FROM csi_t_txn_line_details

Line 7527: UPDATE CSI_T_TRANSACTION_LINES

7523: END IF;
7524: --
7525: debug('Updating CONFIGURATOR Created Transaction Details...');
7526: --
7527: UPDATE CSI_T_TRANSACTION_LINES
7528: set PROCESSING_STATUS = 'PROCESSED'
7529: where transaction_line_id in
7530: ( select transaction_line_id
7531: from CSI_T_TXN_LINE_DETAILS

Line 8279: FROM csi_t_transaction_lines

8275: BEGIN
8276:
8277: SELECT transaction_line_id
8278: INTO l_trx_line_id
8279: FROM csi_t_transaction_lines
8280: WHERE source_transaction_id = x_cre_txn_line_rec.source_transaction_id
8281: and source_transaction_table = x_cre_txn_line_rec.source_transaction_table
8282: and source_transaction_type_id = x_cre_txn_line_rec.source_transaction_type_id;
8283: