View: PO_OWNED_SHIPMENTS

Product:	PO - Purchasing
Description:	Security view for owned purchase order shipments
Implementation/DBA Data:	APPS.PO_OWNED_SHIPMENTS

View Text

SELECT POLL.LINE_LOCATION_ID
, POLL.LAST_UPDATE_DATE
, POLL.LAST_UPDATED_BY
, POLL.PO_HEADER_ID
, POLL.PO_LINE_ID
, POH.AGENT_ID
, POH.TYPE_LOOKUP_CODE
, POLL.LAST_UPDATE_LOGIN
, POLL.CREATION_DATE
, POLL.CREATED_BY
, POLL.QUANTITY
, POLL.QUANTITY_RECEIVED
, POLL.QUANTITY_ACCEPTED
, POLL.QUANTITY_REJECTED
, POLL.QUANTITY_BILLED
, POLL.QUANTITY_CANCELLED
, POLL.UNIT_MEAS_LOOKUP_CODE
, POLL.PO_RELEASE_ID
, POLL.SHIP_TO_LOCATION_ID
, POLL.SHIP_VIA_LOOKUP_CODE
, POLL.NEED_BY_DATE
, POLL.PROMISED_DATE
, POLL.LAST_ACCEPT_DATE
, POLL.PRICE_OVERRIDE
, POLL.ENCUMBERED_FLAG
, POLL.ENCUMBERED_DATE
, POLL.UNENCUMBERED_QUANTITY
, POLL.FOB_LOOKUP_CODE
, POLL.FREIGHT_TERMS_LOOKUP_CODE
, POLL.TAXABLE_FLAG
, POLL.ESTIMATED_TAX_AMOUNT
, POLL.FROM_HEADER_ID
, POLL.FROM_LINE_ID
, POLL.FROM_LINE_LOCATION_ID
, POLL.START_DATE
, POLL.END_DATE
, POLL.LEAD_TIME
, POLL.LEAD_TIME_UNIT
, POLL.PRICE_DISCOUNT
, POLL.TERMS_ID
, POLL.APPROVED_FLAG
, POLL.APPROVED_DATE
, POLL.CLOSED_CODE
, POLL.CANCEL_FLAG
, POLL.CANCELLED_BY
, POLL.CANCEL_DATE
, POLL.CANCEL_REASON
, POLL.FIRM_STATUS_LOOKUP_CODE
, POLL.FIRM_DATE
, POLL.RECEIVING_ROUTING_ID
, POLL.INSPECTION_REQUIRED_FLAG
, POLL.RECEIPT_REQUIRED_FLAG
, POLL.QTY_RCV_TOLERANCE
, POLL.QTY_RCV_EXCEPTION_CODE
, POLL.ENFORCE_SHIP_TO_LOCATION_CODE
, POLL.ALLOW_SUBSTITUTE_RECEIPTS_FLAG
, POLL.DAYS_EARLY_RECEIPT_ALLOWED
, POLL.DAYS_LATE_RECEIPT_ALLOWED
, POLL.RECEIPT_DAYS_EXCEPTION_CODE
, POLL.SHIPMENT_NUM
, POLL.SOURCE_SHIPMENT_ID
, POLL.SHIPMENT_TYPE
, POLL.SHIP_TO_ORGANIZATION_ID
, POLL.ACCRUE_ON_RECEIPT_FLAG
, POLL.USSGL_TRANSACTION_CODE
, POLL.GOVERNMENT_CONTEXT
, POLL.ATTRIBUTE_CATEGORY
, POLL.ATTRIBUTE1
, POLL.ATTRIBUTE2
, POLL.ATTRIBUTE3
, POLL.ATTRIBUTE4
, POLL.ATTRIBUTE5
, POLL.ATTRIBUTE6
, POLL.ATTRIBUTE7
, POLL.ATTRIBUTE8
, POLL.ATTRIBUTE9
, POLL.ATTRIBUTE10
, POLL.ATTRIBUTE11
, POLL.ATTRIBUTE12
, POLL.ATTRIBUTE13
, POLL.ATTRIBUTE14
, POLL.ATTRIBUTE15
, POLL.TAX_CODE_ID
, POLL.ORG_ID
FROM PO_LINE_LOCATIONS POLL
, PO_HEADERS_ALL POH
WHERE POH.PO_HEADER_ID = POLL.PO_HEADER_ID

Columns