View: PO_REQEXPRESS_LINES_V

Product:	PO - Purchasing
Description:	- Retrofitted
Implementation/DBA Data:	APPS.PO_REQEXPRESS_LINES_V

View Text

SELECT RXL.ROWID
, RXL.EXPRESS_NAME
, RXL.SEQUENCE_NUM
, RXL.LAST_UPDATE_DATE
, RXL.LAST_UPDATED_BY
, RXL.CREATION_DATE
, RXL.PO_HEADER_ID
, RXL.PO_LINE_ID
, RXL.CREATED_BY
, RXL.LAST_UPDATE_LOGIN
, RXL.ITEM_ID
, RXL.LINE_TYPE_ID
, RXL.ITEM_REVISION
, RXL.CATEGORY_ID
, RXL.UNIT_MEAS_LOOKUP_CODE
, RXL.UNIT_PRICE
, RXL.SUGGESTED_VENDOR_ID
, RXL.SUGGESTED_VENDOR_SITE_ID
, RXL.SUGGESTED_VENDOR_CONTACT_ID
, RXL.SUGGESTED_VENDOR_PRODUCT_CODE
, RXL.SUGGESTED_BUYER_ID
, RXL.RFQ_REQUIRED_FLAG
, RXL.VENDOR_SOURCE_CONTEXT
, RXL.SOURCE_TYPE_CODE
, RXL.SOURCE_ORGANIZATION_ID
, RXL.SOURCE_SUBINVENTORY
, RXL.ITEM_DESCRIPTION
, RXL.ORG_ID
, PLT.LINE_TYPE
, PLT.ORDER_TYPE_LOOKUP_CODE
, PLC.DISPLAYED_FIELD
, PO_INQ_SV.GET_PERSON_NAME(RXL.SUGGESTED_BUYER_ID)
, V.VENDOR_NAME
, DECODE (VC.LAST_NAME
, NULL
, NULL
, VC.LAST_NAME||'
, '|| VC.FIRST_NAME)
, VS.VENDOR_SITE_CODE
, OOD.ORGANIZATION_NAME
, RXL.ATTRIBUTE_CATEGORY
, RXL.ATTRIBUTE1
, RXL.ATTRIBUTE2
, RXL.ATTRIBUTE3
, RXL.ATTRIBUTE4
, RXL.ATTRIBUTE5
, RXL.ATTRIBUTE6
, RXL.ATTRIBUTE7
, RXL.ATTRIBUTE8
, RXL.ATTRIBUTE9
, RXL.ATTRIBUTE10
, RXL.ATTRIBUTE11
, RXL.ATTRIBUTE12
, RXL.ATTRIBUTE13
, RXL.ATTRIBUTE14
, RXL.ATTRIBUTE15
, RXL.AMOUNT
, PLT.PURCHASE_BASIS
, RXL.SUGGESTED_QUANTITY
, RXL.NEGOTIATED_BY_PREPARER_FLAG
FROM PO_LOOKUP_CODES PLC
, ORG_ORGANIZATION_DEFINITIONS OOD
, PO_LINE_TYPES PLT
, PO_VENDOR_CONTACTS VC
, PO_VENDOR_SITES_ALL VS
, PO_VENDORS V
, PO_REQEXPRESS_LINES RXL
WHERE PLT.LINE_TYPE_ID = RXL.LINE_TYPE_ID
AND PLC.LOOKUP_TYPE = 'REQUISITION SOURCE TYPE'
AND PLC.LOOKUP_CODE = RXL.SOURCE_TYPE_CODE
AND V.VENDOR_ID (+) = RXL.SUGGESTED_VENDOR_ID
AND VC.VENDOR_CONTACT_ID (+) = RXL.SUGGESTED_VENDOR_CONTACT_ID
AND VS.VENDOR_SITE_ID (+) = RXL.SUGGESTED_VENDOR_SITE_ID
AND OOD.ORGANIZATION_ID(+) = RXL.SOURCE_ORGANIZATION_ID

Columns