APPS.CSI_UTL_PKG dependencies on CSI_T_TRANSACTION_LINES

Line 1380: FROM csi_t_transaction_lines

1376: api_log('Get_trx_type_id');
1377:
1378: SELECT source_transaction_type_id
1379: INTO l_trx_type_id
1380: FROM csi_t_transaction_lines
1381: WHERE transaction_line_id = p_trx_line_id;
1382: RETURN l_trx_type_id;
1383:
1384: exception

Line 1407: FROM csi_t_transaction_lines

1403: api_log('Get_trx_line_id');
1404:
1405: SELECT transaction_line_id
1406: INTO l_trx_line_id
1407: FROM csi_t_transaction_lines
1408: WHERE source_transaction_id = p_src_trx_id
1409: AND source_transaction_table = p_src_table_name;
1410: RETURN l_trx_line_id;
1411: exception

Line 2242: FROM csi_t_transaction_lines b

2238: processing_status = 'ERROR'
2239: WHERE a.processing_status <> l_literal1
2240: AND a.source_transaction_flag = 'Y'
2241: AND a.transaction_line_id = (SELECT b.transaction_line_id -- changes for the bug 2851485
2242: FROM csi_t_transaction_lines b
2243: WHERE -- a.transaction_line_id = b.transaction_line_id AND -- Commented for Perf Bug 4311676
2244: b.source_transaction_id = p_source_trx_id
2245: AND b.source_transaction_table = p_source_trx_table);
2246:

Line 2861: csi_t_transaction_lines ctl

2857: ctld.transaction_line_id,
2858: ctld.transaction_system_id,
2859: ctld.csi_system_id
2860: FROM csi_t_txn_line_details ctld,
2861: csi_t_transaction_lines ctl
2862: WHERE ctl.source_transaction_id = p_src_txn_id
2863: AND ctl.source_transaction_table = p_src_txn_table
2864: AND ctld.transaction_line_id = ctl.transaction_line_id
2865: AND ctld.quantity > 1;

Line 5354: csi_t_transaction_lines b

5350: a.transaction_line_id,
5351: a.transaction_system_id,
5352: a.csi_system_id
5353: FROM csi_t_txn_line_details a,
5354: csi_t_transaction_lines b
5355: WHERE a.transaction_line_id = b.transaction_line_id
5356: AND b.source_transaction_id = p_src_trx_id
5357: AND b.source_transaction_table = p_src_trx_table
5358: AND a.source_transaction_flag = 'Y'

Line 6117: csi_t_transaction_lines b

6113: CURSOR source_txn_table_cur (c_txn_line_detail_id IN NUMBER)
6114: IS
6115: SELECT source_transaction_table, source_transaction_id
6116: FROM csi_t_txn_line_details a ,
6117: csi_t_transaction_lines b
6118: WHERE a.transaction_line_id = b.transaction_line_id
6119: AND a.txn_line_detail_id = c_txn_line_detail_id ;
6120:
6121:

Line 6135: csi_t_transaction_lines b ,

6131: IS
6132: ---For Shippable and Non-shippable Items--
6133: SELECT a.*
6134: FROM csi_t_txn_line_details a ,
6135: csi_t_transaction_lines b ,
6136: mtl_system_items_b c
6137: WHERE a.transaction_line_id = b.transaction_line_id
6138: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6139: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))

Line 6182: From csi_t_transaction_lines tl, csi_t_txn_line_details tld

6178:
6179: Begin
6180: Select source_transaction_id
6181: Into l_orig_oe_src_txn_id
6182: From csi_t_transaction_lines tl, csi_t_txn_line_details tld
6183: Where tld.transaction_line_id = tl.transaction_line_id
6184: And tld.txn_line_detail_id = l_orig_oe_tld;
6185: Exception when others Then
6186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 6884: FROM csi_t_transaction_lines ctl,

6880: l_processed boolean := FALSE;
6881:
6882: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS
6883: SELECT 'X'
6884: FROM csi_t_transaction_lines ctl,
6885: csi_t_txn_line_details ctld
6886: WHERE ctl.source_transaction_id = p_ord_line_id
6887: AND ctl.source_transaction_table = 'WSH_DELIVERY_DETAILS'
6888: AND ctld.transaction_line_id = ctl.transaction_line_id