View: QA_SPEC_ORG_ASSIGNMENTS_V

Product:	QA - Quality
Description:	View used in spec org assignment window
Implementation/DBA Data:	APPS.QA_SPEC_ORG_ASSIGNMENTS_V

View Text

SELECT QS2.ROWID ROW_ID
, QS1.SPEC_ID
, QS1.SPEC_NAME
, QS2.SPEC_ID CHILD_SPEC_ID
, NVL(QS2.SPEC_NAME
, SUBSTR(QS1.SPEC_NAME
, 1
, 26)||' '||QS1.CHILD_ORGANIZATION_CODE) CHILD_SPEC_NAME
, QS2.SPEC_NAME CHILD_SPEC_NAME_OLD
, QS1.ORGANIZATION_ID
, MP.ORGANIZATION_CODE
, HRORG.NAME
, DECODE(QS2.SPEC_ID
, NULL
, 2
, 1) ASSIGN_FLAG
, QS1.ITEM_ID
, QS1.CHILD_ORGANIZATION_ID
, QS1.CHILD_ORGANIZATION_CODE
, QS1.CHILD_ORGANIZATION_NAME
FROM QA_SPEC_ORGS_V QS1
, QA_SPECS QS2
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL HRORG
WHERE QS1.ORGANIZATION_ID = MP.ORGANIZATION_ID (+)
AND QS1.ORGANIZATION_ID = HRORG.ORGANIZATION_ID (+)
AND HRORG.LANGUAGE(+) = USERENV('LANG')
AND QS1.SPEC_ID = QS2.COMMON_SPEC_ID (+)
AND QS1.CHILD_ORGANIZATION_ID = QS2.ORGANIZATION_ID (+)
AND (QS2.SPEC_ID IS NULL OR QS2.SPEC_ID <> QS2.COMMON_SPEC_ID)

Columns