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 2903: csi_t_transaction_lines ctl

2899: ctld.transaction_line_id,
2900: ctld.transaction_system_id,
2901: ctld.csi_system_id
2902: FROM csi_t_txn_line_details ctld,
2903: csi_t_transaction_lines ctl
2904: WHERE ctl.source_transaction_id = p_src_txn_id
2905: AND ctl.source_transaction_table = p_src_txn_table
2906: AND ctld.transaction_line_id = ctl.transaction_line_id
2907: AND ctld.quantity > 1;

Line 5433: csi_t_transaction_lines b

5429: a.transaction_line_id,
5430: a.transaction_system_id,
5431: a.csi_system_id
5432: FROM csi_t_txn_line_details a,
5433: csi_t_transaction_lines b
5434: WHERE a.transaction_line_id = b.transaction_line_id
5435: AND b.source_transaction_id = p_src_trx_id
5436: AND b.source_transaction_table = p_src_trx_table
5437: AND a.source_transaction_flag = 'Y'

Line 6196: csi_t_transaction_lines b

6192: CURSOR source_txn_table_cur (c_txn_line_detail_id IN NUMBER)
6193: IS
6194: SELECT source_transaction_table, source_transaction_id
6195: FROM csi_t_txn_line_details a ,
6196: csi_t_transaction_lines b
6197: WHERE a.transaction_line_id = b.transaction_line_id
6198: AND a.txn_line_detail_id = c_txn_line_detail_id ;
6199:
6200:

Line 6214: csi_t_transaction_lines b ,

6210: IS
6211: ---For Shippable and Non-shippable Items--
6212: SELECT a.*
6213: FROM csi_t_txn_line_details a ,
6214: csi_t_transaction_lines b ,
6215: mtl_system_items_b c
6216: WHERE a.transaction_line_id = b.transaction_line_id
6217: AND ((b.source_transaction_table = 'WSH_DELIVERY_DETAILS' AND c.shippable_item_flag = 'Y')
6218: OR (b.source_transaction_table = 'OE_ORDER_LINES_ALL' AND c.shippable_item_flag = 'N'))

Line 6261: From csi_t_transaction_lines tl, csi_t_txn_line_details tld

6257:
6258: Begin
6259: Select source_transaction_id
6260: Into l_orig_oe_src_txn_id
6261: From csi_t_transaction_lines tl, csi_t_txn_line_details tld
6262: Where tld.transaction_line_id = tl.transaction_line_id
6263: And tld.txn_line_detail_id = l_orig_oe_tld;
6264: Exception when others Then
6265: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');

Line 6972: FROM csi_t_transaction_lines ctl,

6968: l_processed boolean := FALSE;
6969:
6970: CURSOR tld_cur (p_ord_line_id IN number, p_instance_id IN number) IS
6971: SELECT 'X'
6972: FROM csi_t_transaction_lines ctl,
6973: csi_t_txn_line_details ctld
6974: WHERE ctl.source_transaction_id = p_ord_line_id
6975: AND ctl.source_transaction_table = 'WSH_DELIVERY_DETAILS'
6976: AND ctld.transaction_line_id = ctl.transaction_line_id