VIEW: APPS.QA_SPEC_ORG_ASSIGNMENTS_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)