APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_T_TXN_LINE_DETAILS

Line 5192: -- Check whether the instance_id resides in CSI_T_TXN_LINE_DETAILS in 'ERROR' status.

5188: END IF;
5189: END LOOP;
5190: -- End modification for bug 6755879, FP of bug 6680634
5191: END IF;
5192: -- Check whether the instance_id resides in CSI_T_TXN_LINE_DETAILS in 'ERROR' status.
5193: l_src_txn_id := NULL;
5194: l_src_txn_type_id := NULL;
5195: Begin
5196: select line.source_transaction_id,line.source_transaction_type_id

Line 5198: from CSI_T_TXN_LINE_DETAILS det,

5194: l_src_txn_type_id := NULL;
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) )

Line 5871: FROM csi_t_txn_line_details ctld,

5867:
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'