DBA Data[Home] [Help]

APPS.CSI_II_RELATIONSHIPS_PVT dependencies on CSI_ITEM_INSTANCE_LOCKS

Line 6441: FROM csi_item_instance_locks

6437: --Added for Bug 12357214
6438: BEGIN
6439: SELECT l_lock_id
6440: INTO l_lock_id
6441: FROM csi_item_instance_locks
6442: WHERE lock_status IS NOT NULL
6443: AND lock_status <> 0
6444: AND instance_id = l_relship_csr.object_id
6445: AND nvl(lock_source_header_ref, fnd_api.g_miss_char) <> nvl(p_txn_rec.SOURCE_HEADER_REF, fnd_api.g_miss_char);

Line 6477: FROM csi_item_instance_locks

6473: --Added for Bug 12357214
6474: BEGIN
6475: SELECT l_lock_id
6476: INTO l_lock_id
6477: FROM csi_item_instance_locks
6478: WHERE lock_status IS NOT NULL
6479: AND lock_status <> 0
6480: AND instance_id= l_relship_csr.subject_id
6481: AND nvl(lock_source_header_ref, fnd_api.g_miss_char) <> nvl(p_txn_rec.SOURCE_HEADER_REF, fnd_api.g_miss_char);