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_DEFAULT_INV_LOC_V

Source

View Text - Preformatted


SELECT cila.resource_id, cila.resource_type, cila.subinventory_code, cila.default_code, csi.parts_loop_id, cila.organization_id, cila.effective_date_start, cila.effective_date_end from csp_inv_loc_assignments cila, csp_sec_inventories csi WHERE csi.secondary_inventory_name = cila.subinventory_code and csi.organization_id = cila.organization_id and cila.default_code in ('IN','OUT')

View Text - HTML Formatted

SELECT CILA.RESOURCE_ID
, CILA.RESOURCE_TYPE
, CILA.SUBINVENTORY_CODE
, CILA.DEFAULT_CODE
, CSI.PARTS_LOOP_ID
, CILA.ORGANIZATION_ID
, CILA.EFFECTIVE_DATE_START
, CILA.EFFECTIVE_DATE_END
FROM CSP_INV_LOC_ASSIGNMENTS CILA
, CSP_SEC_INVENTORIES CSI
WHERE CSI.SECONDARY_INVENTORY_NAME = CILA.SUBINVENTORY_CODE
AND CSI.ORGANIZATION_ID = CILA.ORGANIZATION_ID
AND CILA.DEFAULT_CODE IN ('IN'
, 'OUT')