eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.QA_SPEC_ORGS_V

Source

View Text - Preformatted


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')

View Text - HTML Formatted

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')