VIEW: APPS.POFV_RFQ_SUPPLIERS

Source

View Text - Preformatted

SELECT rs.PO_HEADER_ID, rq.SEGMENT1, rq.ORG_ID, op.NAME, rs.SEQUENCE_NUM, rs.PRINTED_DATE, rs.PRINT_COUNT, '_LA:rs.PRINT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD', '_DF:PO:PO_RFQ_VENDORS:rs', rs.VENDOR_ID, ve.VENDOR_NAME, rs.VENDOR_SITE_ID, vs.VENDOR_SITE_CODE, rs.VENDOR_CONTACT_ID, vc.LAST_NAME || ', ' || vc.FIRST_NAME, rs.CREATION_DATE, rs.CREATED_BY, rs.LAST_UPDATE_DATE, rs.LAST_UPDATED_BY FROM PO_RFQ_VENDORS rs, PO_HEADERS_ALL rq, HR_ALL_ORGANIZATION_UNITS op, PO_VENDORS ve, PO_VENDOR_CONTACTS vc, PO_VENDOR_SITES_ALL vs WHERE rs.PO_HEADER_ID = rq.PO_HEADER_ID AND rq.ORG_ID = op.ORGANIZATION_ID AND rs.VENDOR_ID = ve.VENDOR_ID AND rs.VENDOR_SITE_ID = vs.VENDOR_SITE_ID AND rq.ORG_ID = vs.ORG_ID AND rs.VENDOR_CONTACT_ID = vc.VENDOR_CONTACT_ID(+) WITH READ ONLY

View Text - HTML Formatted

SELECT RS.PO_HEADER_ID
, RQ.SEGMENT1
, RQ.ORG_ID
, OP.NAME
, RS.SEQUENCE_NUM
, RS.PRINTED_DATE
, RS.PRINT_COUNT
, '_LA:RS.PRINT_FLAG:PO_LOOKUP_CODES:YES/NO:DISPLAYED_FIELD'
, '_DF:PO:PO_RFQ_VENDORS:RS'
, RS.VENDOR_ID
, VE.VENDOR_NAME
, RS.VENDOR_SITE_ID
, VS.VENDOR_SITE_CODE
, RS.VENDOR_CONTACT_ID
, VC.LAST_NAME || '
, ' || VC.FIRST_NAME
, RS.CREATION_DATE
, RS.CREATED_BY
, RS.LAST_UPDATE_DATE
, RS.LAST_UPDATED_BY
FROM PO_RFQ_VENDORS RS
, PO_HEADERS_ALL RQ
, HR_ALL_ORGANIZATION_UNITS OP
, PO_VENDORS VE
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
WHERE RS.PO_HEADER_ID = RQ.PO_HEADER_ID
AND RQ.ORG_ID = OP.ORGANIZATION_ID
AND RS.VENDOR_ID = VE.VENDOR_ID
AND RS.VENDOR_SITE_ID = VS.VENDOR_SITE_ID
AND RQ.ORG_ID = VS.ORG_ID
AND RS.VENDOR_CONTACT_ID = VC.VENDOR_CONTACT_ID(+) WITH READ ONLY