[Home] [Help]
View: PMIFV_ORGANIZATION_V
Product: | PMI - Process Manufacturing Intelligence (Obsolete) |
Description: | Process Manufacturing Organizations |
Implementation/DBA Data: |
APPS.PMIFV_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
, PARENTORG.ORGN_NAME
, ORGMASTER.CREATED_BY
, ORGMASTER.CREATION_DATE
, ORGMASTER.LAST_UPDATE_DATE
, ORGMASTER.LAST_UPDATED_BY
FROM SY_ORGN_MST ORGMASTER
, SY_ORGN_MST PARENTORG
WHERE ORGMASTER.ORGN_CODE = PARENTORG.ORGN_CODE
AND ORGMASTER.DELETE_MARK = 0
AND PARENTORG.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 |
PARENT_ORGN_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |