View: QA_SPEC_ORGS_V

Product:	QA - Quality
Description:	Auxiliary view used by qa_spec_org_assignments_v
Implementation/DBA Data:	APPS.QA_SPEC_ORGS_V

View Text

SELECT QS.SPEC_ID
, QS.SPEC_NAME
, QS.ITEM_ID
, QS.ORGANIZATION_ID
, MSI.ORGANIZATION_ID CHILD_ORGANIZATION_ID
, MP.ORGANIZATION_CODE CHILD_ORGANIZATION_CODE
, ORG.NAME CHILD_ORGANIZATION_NAME
FROM QA_SPECS QS
, MTL_SYSTEM_ITEMS_B MSI
, MTL_PARAMETERS MP
, HR_ALL_ORGANIZATION_UNITS_TL ORG
WHERE QS.SPEC_ID = QS.COMMON_SPEC_ID
AND QS.ITEM_ID = MSI.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.LANGUAGE = USERENV('LANG')

Columns