VIEW: APPS.QA_BIS_RESULTS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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