[Home] [Help]
View: JA_AU_SUBINV_LOC_ASSOCS_V
View Text
SELECT DISTINCT JSLA.ROWID
, JSLA.ORGANIZATION_ID
, JSLA.LOCATION_ID
, LOC.LOCATION_CODE
, JSLA.SUBINVENTORY_NAME
, SUB.DESCRIPTION
, JSLA.CREATION_DATE
, JSLA.CREATED_BY
, JSLA.LAST_UPDATE_DATE
, JSLA.LAST_UPDATED_BY
, JSLA.LAST_UPDATE_LOGIN
FROM HR_LOCATIONS LOC
, JA_AU_SUBINV_LOC_ASSOCS JSLA
, MTL_SECONDARY_INVENTORIES SUB
WHERE JSLA.SUBINVENTORY_NAME = SUB.SECONDARY_INVENTORY_NAME
AND JSLA.LOCATION_ID = LOC.LOCATION_ID
AND SUB.ORGANIZATION_ID = JSLA.ORGANIZATION_ID
Columns
Name |
ROW_ID |
ORGANIZATION_ID |
LOCATION_ID |
LOCATION_CODE |
SUBINVENTORY_NAME |
DESCRIPTION |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |