View: QA_BIS_RESULTS_V

Product:	QA - Quality
Description:	BIS Summary Table View
Implementation/DBA Data:	APPS.QA_BIS_RESULTS_V

View Text

SELECT QB.REQUEST_ID
, QB.PROGRAM_APPLICATION_ID
, QB.PROGRAM_ID
, QB.PROGRAM_UPDATE_DATE
, QB.CREATED_BY
, QB.CREATION_DATE
, QB.LAST_UPDATE_LOGIN
, QB.LAST_UPDATED_BY
, QB.LAST_UPDATE_DATE
, QB.QA_CREATION_DATE
, QB.QA_LAST_UPDATE_DATE
, QB.ORGANIZATION_ID
, HAOT.NAME ORGANIZATION_NAME
, QB.PLAN_ID
, QP.NAME PLAN_NAME
, QB.COLLECTION_ID
, QB.OCCURRENCE
, QP.PLAN_TYPE_CODE
, FL.MEANING PLAN_TYPE_MEANING
, QB.ITEM_ID
, MSIT.DESCRIPTION ITEM
, MSIB.LOT_CONTROL_CODE
, QB.LOT_NUMBER
, QB.DEFECT_CODE
, QB.QUANTITY_DEFECTIVE
FROM QA_BIS_RESULTS QB
, QA_PLANS QP
, HR_ALL_ORGANIZATION_UNITS_TL HAOT
, MTL_SYSTEM_ITEMS_B MSIB
, MTL_SYSTEM_ITEMS_TL MSIT
, FND_LOOKUP_VALUES FL
WHERE FL.LOOKUP_TYPE = 'COLLECTION_PLAN_TYPE'
AND FL.LANGUAGE = USERENV('LANG')
AND FL.VIEW_APPLICATION_ID = 3
AND FL.LOOKUP_CODE = QP.PLAN_TYPE_CODE
AND QB.ORGANIZATION_ID = MSIB.ORGANIZATION_ID(+)
AND QB.ITEM_ID = MSIB.INVENTORY_ITEM_ID(+)
AND MSIB.INVENTORY_ITEM_ID = MSIT.INVENTORY_ITEM_ID(+)
AND MSIB.ORGANIZATION_ID = MSIT.ORGANIZATION_ID(+)
AND MSIT.LANGUAGE(+) = USERENV('LANG')
AND QB.ORGANIZATION_ID = HAOT.ORGANIZATION_ID
AND HAOT.LANGUAGE(+) = USERENV('LANG')
AND QB.PLAN_ID = QP.PLAN_ID

Columns