APPS.CSI_DIAGNOSTICS_PKG dependencies on CSI_T_TRANSACTION_LINES

Line 3774: csi_t_transaction_lines tl

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
3778: AND tld.instance_id is not null;

Line 8744: FROM csi_t_transaction_lines ctl,

8740: ORDER by 1 desc, 2 desc;
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

Line 15005: FROM csi_t_transaction_lines ctl,

15001:
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

Line 15497: FROM csi_t_transaction_lines

15493: l_transaction_line_id := null;
15494: BEGIN
15495: SELECT transaction_line_id
15496: INTO l_transaction_line_id
15497: FROM csi_t_transaction_lines
15498: WHERE source_transaction_table = 'OE_ORDER_LINES_ALL'
15499: AND source_transaction_id = l_rma_txn_tbl(i).mtl_src_line_id
15500: AND source_transaction_type_id = 53;
15501: EXCEPTION