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.

VIEW: APPS.CSP_RESOURCE_INV_LOC_V

Source

View Text - Preformatted


SELECT cila.resource_id, cila.resource_type, cila.subinventory_code, csi.condition_type, cila.organization_id, cila.effective_date_start, cila.effective_date_end from csp_inv_loc_assignments cila, csp_sec_inventories csi WHERE csi.organization_id = cila.organization_id and csi.secondary_inventory_name = cila.subinventory_code and csi.condition_type in ('G','B')

View Text - HTML Formatted

SELECT CILA.RESOURCE_ID
, CILA.RESOURCE_TYPE
, CILA.SUBINVENTORY_CODE
, CSI.CONDITION_TYPE
, CILA.ORGANIZATION_ID
, CILA.EFFECTIVE_DATE_START
, CILA.EFFECTIVE_DATE_END
FROM CSP_INV_LOC_ASSIGNMENTS CILA
, CSP_SEC_INVENTORIES CSI
WHERE CSI.ORGANIZATION_ID = CILA.ORGANIZATION_ID
AND CSI.SECONDARY_INVENTORY_NAME = CILA.SUBINVENTORY_CODE
AND CSI.CONDITION_TYPE IN ('G'
, 'B')