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 2508: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized

2504: IF p_instance_rec.location_type_code = 'INVENTORY' AND
2505: p_instance_rec.instance_usage_code NOT IN ('IN_RELATIONSHIP','RETURNED')
2506: THEN
2507: BEGIN
2508: -- srramakr Removed the reference to CSI_I_PARTIES since we have the denormalized
2509: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2510: SELECT '1'
2511: INTO l_count
2512: FROM csi_item_instances a

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

2509: -- columns owner_party_id and owner_party_source_table in CSI_ITEM_INSTANCES
2510: SELECT '1'
2511: INTO l_count
2512: FROM csi_item_instances a
2513: -- ,csi_i_parties b -- Not required as we have the denormalized column in CII
2514: -- WHERE a.instance_id = b.instance_id
2515: WHERE a.inventory_item_id = p_instance_rec.inventory_item_id
2516: AND a.inv_organization_id = p_instance_rec.inv_organization_id
2517: AND a.inv_subinventory_name = p_instance_rec.inv_subinventory_name

Line 3677: FROM csi_i_parties

3673: --
3674: BEGIN
3675: SELECT party_id
3676: INTO l_owner
3677: FROM csi_i_parties
3678: WHERE instance_id = p_instance_id
3679: AND relationship_type_code ='OWNER'
3680: AND (active_end_date >SYSDATE OR active_end_date IS NULL );
3681: EXCEPTION