[Home] [Help]
View: PMIBV_ORGANIZATION_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | Process Manufacturing Organizations |
Implementation/DBA Data: |
APPS.PMIBV_ORGANIZATION_V
|
View Text
SELECT ORGMASTER.ORGN_CODE
, ORGMASTER.ORGN_NAME
, ORGMASTER.PLANT_IND
, ORGMASTER.TAXLOC_CODE
, ORGMASTER.POC_IND
, ORGMASTER.PARENT_ORGN_CODE
, ORGMASTER.CO_CODE
, ORGMASTER.ADDR_ID
, ORGMASTER.ORGANIZATION_ID
, ORGMASTER.CREATED_BY
, ORGMASTER.CREATION_DATE
, ORGMASTER.LAST_UPDATE_DATE
, ORGMASTER.LAST_UPDATED_BY
FROM SY_ORGN_MST ORGMASTER
WHERE ORGMASTER.DELETE_MARK = 0 WITH READ ONLY
Columns
Name |
ORGN_CODE |
ORGN_NAME |
PLANT_IND |
TAXLOC_CODE |
POC_IND |
PARENT_ORGN_CODE |
CO_CODE |
ADDR_ID |
ORGANIZATION_ID |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |