Product: | PO - Purchasing |
---|---|
Description: | Security view for owned requisition lines |
Implementation/DBA Data: | APPS.PO_OWNED_REQUISITION_LINES |
SELECT PORL.REQUISITION_LINE_ID
, PORL.REQUISITION_HEADER_ID
, PORL.LINE_NUM
, PORL.LINE_TYPE_ID
, PORL.CATEGORY_ID
, PORL.ITEM_DESCRIPTION
, PORL.UNIT_MEAS_LOOKUP_CODE
, PORL.UNIT_PRICE
, PORL.QUANTITY
, PORL.DELIVER_TO_LOCATION_ID
, PORL.TO_PERSON_ID
, PORL.LAST_UPDATE_DATE
, PORL.LAST_UPDATED_BY
, PORL.SOURCE_TYPE_CODE
, PORH.PREPARER_ID
, PORL.LAST_UPDATE_LOGIN
, PORL.CREATION_DATE
, PORL.CREATED_BY
, PORL.ITEM_ID
, PORL.ITEM_REVISION
, PORL.QUANTITY_DELIVERED
, PORL.SUGGESTED_BUYER_ID
, PORL.ENCUMBERED_FLAG
, PORL.RFQ_REQUIRED_FLAG
, PORL.NEED_BY_DATE
, PORL.LINE_LOCATION_ID
, PORL.MODIFIED_BY_AGENT_FLAG
, PORL.PARENT_REQ_LINE_ID
, PORL.JUSTIFICATION
, PORL.NOTE_TO_AGENT
, PORL.NOTE_TO_RECEIVER
, PORL.PURCHASING_AGENT_ID
, PORL.BLANKET_PO_HEADER_ID
, PORL.BLANKET_PO_LINE_NUM
, PORL.SUGGESTED_VENDOR_NAME
, PORL.SUGGESTED_VENDOR_LOCATION
, PORL.SUGGESTED_VENDOR_CONTACT
, PORL.SUGGESTED_VENDOR_PHONE
, PORL.SUGGESTED_VENDOR_PRODUCT_CODE
, PORL.UN_NUMBER_ID
, PORL.HAZARD_CLASS_ID
, PORL.MUST_USE_SUGG_VENDOR_FLAG
, PORL.REFERENCE_NUM
, PORL.ON_RFQ_FLAG
, PORL.URGENT_FLAG
, PORL.CANCEL_FLAG
, PORL.SOURCE_ORGANIZATION_ID
, PORL.SOURCE_SUBINVENTORY
, PORL.DESTINATION_TYPE_CODE
, PORL.DESTINATION_ORGANIZATION_ID
, PORL.DESTINATION_SUBINVENTORY
, PORL.QUANTITY_CANCELLED
, PORL.CANCEL_DATE
, PORL.CANCEL_REASON
, PORL.CLOSED_CODE
, PORL.AGENT_RETURN_NOTE
, PORL.CHANGED_AFTER_RESEARCH_FLAG
, PORL.VENDOR_ID
, PORL.VENDOR_SITE_ID
, PORL.VENDOR_CONTACT_ID
, PORL.RESEARCH_AGENT_ID
, PORL.ON_LINE_FLAG
, PORL.WIP_ENTITY_ID
, PORL.WIP_LINE_ID
, PORL.WIP_REPETITIVE_SCHEDULE_ID
, PORL.WIP_OPERATION_SEQ_NUM
, PORL.WIP_RESOURCE_SEQ_NUM
, PORL.BOM_RESOURCE_ID
, PORL.DESTINATION_CONTEXT
, PORL.INVENTORY_SOURCE_CONTEXT
, PORL.VENDOR_SOURCE_CONTEXT
, PORL.USSGL_TRANSACTION_CODE
, PORL.GOVERNMENT_CONTEXT
, PORL.ATTRIBUTE_CATEGORY
, PORL.ATTRIBUTE1
, PORL.ATTRIBUTE2
, PORL.ATTRIBUTE3
, PORL.ATTRIBUTE4
, PORL.ATTRIBUTE5
, PORL.ATTRIBUTE6
, PORL.ATTRIBUTE7
, PORL.ATTRIBUTE8
, PORL.ATTRIBUTE9
, PORL.ATTRIBUTE10
, PORL.ATTRIBUTE11
, PORL.ATTRIBUTE12
, PORL.ATTRIBUTE13
, PORL.ATTRIBUTE14
, PORL.ATTRIBUTE15
, PORL.ORG_ID
FROM PO_REQUISITION_LINES PORL
, PO_REQUISITION_HEADERS_ALL PORH
WHERE PORH.REQUISITION_HEADER_ID = PORL.REQUISITION_HEADER_ID