DBA Data[Home] [Help]

VIEW: APPS.PMIBV_ORGANIZATION_V

Source

View Text - Preformatted

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
View Text - HTML Formatted

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