APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 5199: CSI_T_TRANSACTION_LINES line

5195: Begin
5196: select line.source_transaction_id,line.source_transaction_type_id
5197: into l_src_txn_id,l_src_txn_type_id
5198: from CSI_T_TXN_LINE_DETAILS det,
5199: CSI_T_TRANSACTION_LINES line
5200: where ( (det.instance_id = p_instance_rec.instance_id) OR
5201: (det.inventory_item_id = p_instance_rec.inventory_item_id AND
5202: det.serial_number = p_instance_rec.serial_number) )
5203: and nvl(det.processing_status,'SUBMIT') = 'ERROR'

Line 5872: csi_t_transaction_lines ctl

5868: CURSOR tld_cur IS
5869: SELECT ctl.source_transaction_table,
5870: ctl.source_transaction_id
5871: FROM csi_t_txn_line_details ctld,
5872: csi_t_transaction_lines ctl
5873: WHERE ctld.inventory_item_id = p_inventory_item_id
5874: AND ctld.serial_number = p_serial_number
5875: AND nvl(ctld.processing_status, 'SUBMIT') <> 'PROCESSED'
5876: AND ctl.transaction_line_id = ctld.transaction_line_id;