View: QA_PO_NUMBERS_LOV_V

Product:	QA - Quality
Description:	PO Number collection element LOV validation view.
Implementation/DBA Data:	APPS.QA_PO_NUMBERS_LOV_V

View Text

SELECT PO.PO_HEADER_ID
, PO.SEGMENT1
, PO.TYPE_NAME
, PO.TYPE_LOOKUP_CODE
, PO.VENDOR_NAME
, PO.FULL_NAME
, PO.DISPLAYED_FIELD
, PO.CREATION_DATE
, PO.ORG_ID
, HR.NAME
, PO.COMMENTS
, TRIM(PO.COMMENTS || ' (' || HR.NAME || ')')
FROM PO_POS_ALL_TRX_V PO
, HR_ALL_ORGANIZATION_UNITS_TL HR
WHERE PO.ORG_ID = HR.ORGANIZATION_ID
AND HR.LANGUAGE = USERENV('LANG')

Columns