[Home] [Help]
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
| LINE_LOCATION_ID |
| LAST_UPDATE_DATE |
| LAST_UPDATED_BY |
| PO_HEADER_ID |
| PO_LINE_ID |
| OWNER_ID |
| HEADER_TYPE_CODE |
| LAST_UPDATE_LOGIN |
| CREATION_DATE |
| CREATED_BY |
| QUANTITY |
| QUANTITY_RECEIVED |
| QUANTITY_ACCEPTED |
| QUANTITY_REJECTED |
| QUANTITY_BILLED |
| QUANTITY_CANCELLED |
| UNIT_MEAS_LOOKUP_CODE |
| PO_RELEASE_ID |
| SHIP_TO_LOCATION_ID |
| SHIP_VIA_LOOKUP_CODE |
| NEED_BY_DATE |
| PROMISED_DATE |
| LAST_ACCEPT_DATE |
| PRICE_OVERRIDE |
| ENCUMBERED_FLAG |
| ENCUMBERED_DATE |
| UNENCUMBERED_QUANTITY |
| FOB_LOOKUP_CODE |
| FREIGHT_TERMS_LOOKUP_CODE |
| TAXABLE_FLAG |
| ESTIMATED_TAX_AMOUNT |
| FROM_HEADER_ID |
| FROM_LINE_ID |
| FROM_LINE_LOCATION_ID |
| START_DATE |
| END_DATE |
| LEAD_TIME |
| LEAD_TIME_UNIT |
| PRICE_DISCOUNT |
| TERMS_ID |
| APPROVED_FLAG |
| APPROVED_DATE |
| CLOSED_CODE |
| CANCEL_FLAG |
| CANCELLED_BY |
| CANCEL_DATE |
| CANCEL_REASON |
| FIRM_STATUS_LOOKUP_CODE |
| FIRM_DATE |
| RECEIVING_ROUTING_ID |
| INSPECTION_REQUIRED_FLAG |
| RECEIPT_REQUIRED_FLAG |
| QTY_RCV_TOLERANCE |
| QTY_RCV_EXCEPTION_CODE |
| ENFORCE_SHIP_TO_LOCATION_CODE |
| ALLOW_SUBSTITUTE_RECEIPTS_FLAG |
| DAYS_EARLY_RECEIPT_ALLOWED |
| DAYS_LATE_RECEIPT_ALLOWED |
| RECEIPT_DAYS_EXCEPTION_CODE |
| SHIPMENT_NUM |
| SOURCE_SHIPMENT_ID |
| SHIPMENT_TYPE |
| SHIP_TO_ORGANIZATION_ID |
| ACCRUE_ON_RECEIPT_FLAG |
| USSGL_TRANSACTION_CODE |
| GOVERNMENT_CONTEXT |
| ATTRIBUTE_CATEGORY |
| ATTRIBUTE1 |
| ATTRIBUTE2 |
| ATTRIBUTE3 |
| ATTRIBUTE4 |
| ATTRIBUTE5 |
| ATTRIBUTE6 |
| ATTRIBUTE7 |
| ATTRIBUTE8 |
| ATTRIBUTE9 |
| ATTRIBUTE10 |
| ATTRIBUTE11 |
| ATTRIBUTE12 |
| ATTRIBUTE13 |
| ATTRIBUTE14 |
| ATTRIBUTE15 |
| TAX_CODE_ID |
| ORG_ID |
| Name |