APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_T_TRANSACTION_LINES

Line 5452: CSI_T_TRANSACTION_LINES line

5448: Begin
5449: select line.source_transaction_id,line.source_transaction_type_id
5450: into l_src_txn_id,l_src_txn_type_id
5451: from CSI_T_TXN_LINE_DETAILS det,
5452: CSI_T_TRANSACTION_LINES line
5453: where ( (det.instance_id = p_instance_rec.instance_id) OR
5454: (det.inventory_item_id = p_instance_rec.inventory_item_id AND
5455: det.serial_number = p_instance_rec.serial_number) )
5456: and nvl(det.processing_status,'SUBMIT') = 'ERROR'

Line 6125: csi_t_transaction_lines ctl

6121: CURSOR tld_cur IS
6122: SELECT ctl.source_transaction_table,
6123: ctl.source_transaction_id
6124: FROM csi_t_txn_line_details ctld,
6125: csi_t_transaction_lines ctl
6126: WHERE ctld.inventory_item_id = p_inventory_item_id
6127: AND ctld.serial_number = p_serial_number
6128: AND nvl(ctld.processing_status, 'SUBMIT') <> 'PROCESSED'
6129: AND ctl.transaction_line_id = ctld.transaction_line_id;