[Home] [Help]
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
Name |
SPEC_ID |
SPEC_NAME |
ITEM_ID |
ORGANIZATION_ID |
CHILD_ORGANIZATION_ID |
CHILD_ORGANIZATION_CODE |
CHILD_ORGANIZATION_NAME |