View: JAI_CMN_ORG_DTLS_V

Product:	JA - Asia/Pacific Localizations
Description:
Implementation/DBA Data:	APPS.JAI_CMN_ORG_DTLS_V

View Text

SELECT JHR.EC_CODE EC_CODE
, ORG.ORGANIZATION_CODE ORAGNIZATION_CODE
, ORG.ORGANIZATION_NAME ORGANIZATION_NAME
, ORG.ORGANIZATION_ID ORGANIZATION_ID
, HRL.LOCATION_CODE LOCATION_CODE
, 'MANUFACTURING' ORGTYPE
FROM JAI_CMN_INVENTORY_ORGS JHR
, ORG_ORGANIZATION_DEFINITIONS ORG
, HR_LOCATIONS HRL
WHERE JHR.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND JHR.LOCATION_ID = HRL.LOCATION_ID(+)
AND NVL(MASTER_ORG_FLAG
, 'N')='Y'
AND NVL(MANUFACTURING
, 'N')='Y'
AND NVL(TRADING
, 'N')='N'
AND EC_CODE IS NOT NULL UNION ALL SELECT JHR.TR_EC_CODE EC_CODE
, ORG.ORGANIZATION_CODE ORGANIZATION_CODE
, ORG.ORGANIZATION_NAME ORGANIZATION_NAME
, ORG.ORGANIZATION_ID ORGANIZATION_ID
, HRL.LOCATION_CODE LOCATION_CODE
, 'TRADING' ORGTYPE
FROM JAI_CMN_INVENTORY_ORGS JHR
, ORG_ORGANIZATION_DEFINITIONS ORG
, HR_LOCATIONS HRL
WHERE JHR.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND JHR.LOCATION_ID = HRL.LOCATION_ID(+)
AND NVL(MASTER_ORG_FLAG
, 'N')='Y'
AND NVL(MANUFACTURING
, 'N')='N'
AND NVL(TRADING
, 'N')='Y'
AND TR_EC_CODE IS NOT NULL

Columns