eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_VLD_PVT dependencies on CSI_I_PARTIES

Line 2463: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized

2459: IF p_instance_rec.location_type_code = 'INVENTORY' AND
2460: p_instance_rec.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2461: THEN
2462: BEGIN
2463: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2464: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2465: SELECT '1'
2466: INTO l_count
2467: FROM csi_item_instances a

Line 2468: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII

2464: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2465: SELECT '1'
2466: INTO l_count
2467: FROM csi_item_instances a
2468: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII
2469: -- WHERE a.instance_id = b.instance_id
2470: WHERE a.inventory_item_id = p_instance_rec.inventory_item_id
2471: AND a.inv_organization_id = p_instance_rec.inv_organization_id
2472: AND a.inv_subinventory_name = p_instance_rec.inv_subinventory_name

Line 3598: FROM csi_i_parties

3594: --
3595: BEGIN
3596: SELECT party_id
3597: INTO l_owner
3598: FROM csi_i_parties
3599: WHERE instance_id = p_instance_id
3600: AND relationship_type_code ='OWNER'
3601: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
3602: EXCEPTION