APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_T_TXN_LINE_DETAILS

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

5441: END IF;
5442: END LOOP;
5443: -- End modification for bug 6755879, FP of bug 6680634
5444: END IF;
5445: -- Check whether the instance_id resides in CSI_T_TXN_LINE_DETAILS in 'ERROR' status.
5446: l_src_txn_id := NULL;
5447: l_src_txn_type_id := NULL;
5448: Begin
5449: select line.source_transaction_id,line.source_transaction_type_id

Line 5451: from CSI_T_TXN_LINE_DETAILS det,

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

Line 6124: FROM csi_t_txn_line_details ctld,

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