VIEW: APPS.PO_REQEXPRESS_LINES_V

Source

View Text - Preformatted

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 VC.VENDOR_SITE_ID (+) = RXL.SUGGESTED_VENDOR_SITE_ID AND OOD.ORGANIZATION_ID(+) = RXL.SOURCE_ORGANIZATION_ID

View Text - HTML Formatted

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 VC.VENDOR_SITE_ID (+) = RXL.SUGGESTED_VENDOR_SITE_ID
AND OOD.ORGANIZATION_ID(+) = RXL.SOURCE_ORGANIZATION_ID