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 15006: csi_t_txn_line_details ctld

15002: --
15003: CURSOR tld_cur(p_rma_line_id in number) is
15004: SELECT ctld.sub_type_id, ctld.instance_id
15005: FROM csi_t_transaction_lines ctl,
15006: csi_t_txn_line_details ctld
15007: WHERE ctl.source_transaction_table = 'OE_ORDER_LINES_ALL'
15008: AND ctl.source_transaction_id = p_rma_line_id
15009: AND ctld.transaction_line_id = ctl.transaction_line_id
15010: AND ctld.source_transaction_flag = 'Y';

Line 15429: FROM csi_t_txn_line_details

15425: IS
15426: SELECT txn_line_detail_id ,
15427: instance_id,
15428: quantity
15429: FROM csi_t_txn_line_details
15430: WHERE transaction_line_id = p_transaction_line_id
15431: AND source_transaction_flag = 'Y';
15432:
15433:

Line 15593: UPDATE csi_t_txn_line_details

15589: END LOOP;
15590:
15591: -- if only one then
15592: IF l_tld_count = 1 THEN
15593: UPDATE csi_t_txn_line_details
15594: SET instance_id = l_instance_tbl(j).instance_id,
15595: instance_exists_flag = 'Y'
15596: WHERE txn_line_detail_id = l_txn_line_detail_id;
15597: l_processed_flag := 'Y';