VIEW: APPS.QA_PO_NUMBERS_LOV_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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