VIEW: APPS.PO_OWNED_SHIPMENTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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