APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_T_TXN_LINE_DETAILS

Line 3773: FROM csi_t_txn_line_details tld,

3769: SELECT tld.instance_id,
3770: tld.serial_number,
3771: tld.inventory_item_id,
3772: tld.inv_organization_id
3773: FROM csi_t_txn_line_details tld,
3774: csi_t_transaction_lines tl
3775: WHERE tl.source_transaction_table = 'OE_ORDER_LINES_ALL'
3776: AND tl.source_transaction_id = p_order_line_id
3777: AND tld.transaction_line_id = tl.transaction_line_id

Line 8745: csi_t_txn_line_details ctld

8741:
8742: CURSOR tld_cur(p_rma_line_id in number) is
8743: SELECT ctld.sub_type_id
8744: FROM csi_t_transaction_lines ctl,
8745: csi_t_txn_line_details ctld
8746: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
8747: AND ctl.source_transaction_type_id = 53
8748: AND ctl.source_transaction_id = p_rma_line_id
8749: AND ctld.transaction_line_id = ctl.transaction_line_id

Line 14995: csi_t_txn_line_details ctld

14991: --
14992: CURSOR tld_cur(p_rma_line_id in number) is
14993: SELECT ctld.sub_type_id, ctld.instance_id
14994: FROM csi_t_transaction_lines ctl,
14995: csi_t_txn_line_details ctld
14996: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
14997: AND ctl.source_transaction_id = p_rma_line_id
14998: AND ctld.transaction_line_id = ctl.transaction_line_id
14999: AND ctld.source_transaction_flag = 'Y';

Line 15418: FROM csi_t_txn_line_details

15414: IS
15415: SELECT txn_line_detail_id ,
15416: instance_id,
15417: quantity
15418: FROM csi_t_txn_line_details
15419: WHERE transaction_line_id = p_transaction_line_id
15420: AND source_transaction_flag = 'Y';
15421:
15422:

Line 15582: UPDATE csi_t_txn_line_details

15578: END LOOP;
15579:
15580: -- if only one then
15581: IF l_tld_count = 1 THEN
15582: UPDATE csi_t_txn_line_details
15583: SET instance_id = l_instance_tbl(j).instance_id,
15584: instance_exists_flag = 'Y'
15585: WHERE txn_line_detail_id = l_txn_line_detail_id;
15586: l_processed_flag := 'Y';