[Home] [Help]
View: GMI_ITEM_ORGANIZATIONS_V1
Product: | GMI - Process Manufacturing Inventory |
Description: | View of GMI_ITEM_ORGANIZATIONS plus organization name, code, and master org |
Implementation/DBA Data: |
APPS.GMI_ITEM_ORGANIZATIONS_V1
|
View Text
SELECT I.ORGANIZATION_ID
, I.CREATED_BY
, I.CREATION_DATE
, I.LAST_UPDATED_BY
, I.LAST_UPDATE_DATE
, I.LAST_UPDATE_LOGIN
, D.ORGANIZATION_CODE
, D.ORGANIZATION_NAME
, P.MASTER_ORGANIZATION_ID
FROM GMI_ITEM_ORGANIZATIONS I
, ORG_ORGANIZATION_DEFINITIONS D
, MTL_PARAMETERS P
WHERE I.ORGANIZATION_ID = D.ORGANIZATION_ID
AND D.ORGANIZATION_ID = P.ORGANIZATION_ID
Columns
Name |
ORGANIZATION_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
MASTER_ORGANIZATION_ID |