eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.PO_OWNED_SHIPMENTS

Object Details

Object Name:	PO_OWNED_SHIPMENTS
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.PO_OWNED_SHIPMENTS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
LINE_LOCATION_ID	NUMBER		Yes	Document shipment schedule unique identifier
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID	NUMBER		Yes	Document header unique identifier
PO_LINE_ID	NUMBER		Yes	Document line unique identifier
OWNER_ID	NUMBER	(9)	Yes	Buyer unique identifier
HEADER_TYPE_CODE	VARCHAR2	(25)	Yes	Type of the purchase order
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
QUANTITY	NUMBER			Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
QUANTITY_RECEIVED	NUMBER			Quantity received to date
QUANTITY_ACCEPTED	NUMBER			Quantity accepted to date after inspection
QUANTITY_REJECTED	NUMBER			Quantity rejected to date after inspection
QUANTITY_BILLED	NUMBER			Quantity invoiced to date by Oracle Payables
QUANTITY_CANCELLED	NUMBER			Quantity cancelled
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Price break quantity unit of measure
PO_RELEASE_ID	NUMBER			Release unique identifier for a release shipment
SHIP_TO_LOCATION_ID	NUMBER			Unique identifier for the ship-to location
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)		Type of carrier for the RFQ or Quotation shipment
NEED_BY_DATE	DATE			Need By Date for the shipment schedule
PROMISED_DATE	DATE			Vendor promised delivery date
LAST_ACCEPT_DATE	DATE			Latest acceptable receipt date for the shipment
PRICE_OVERRIDE	NUMBER			Order shipment price or break price for blanket purchase orders, RFQs and quotations
ENCUMBERED_FLAG	VARCHAR2	(1)		Indicates whether the shipment is encumbered or not
ENCUMBERED_DATE	DATE			Date of encumbrance for the shipment
UNENCUMBERED_QUANTITY	NUMBER			Encumbered quantity to date (Unused since Version 7.0)
FOB_LOOKUP_CODE	VARCHAR2	(25)		Type of free-on-board terms for the shipment
FREIGHT_TERMS_LOOKUP_CODE	VARCHAR2	(25)		Type of freight terms for the shipment
TAXABLE_FLAG	VARCHAR2	(1)		Indicates whether the shipment is taxable or not
ESTIMATED_TAX_AMOUNT	NUMBER			Estimated tax amount for the purchase order shipment (Unused since Version 6.0)
FROM_HEADER_ID	NUMBER			Unique identifier of the RFQ used to autocreate the quotation
FROM_LINE_ID	NUMBER			Unique identifier of the RFQ line used to autocreate the quotation line
FROM_LINE_LOCATION_ID	NUMBER			Unique identifier of the RFQ shipment used to autocreate a quotation shipment
START_DATE	DATE			Effective date of the price break (applies to RFQ's and quotations only)
END_DATE	DATE			Expiration date of the price break (applies to RFQ's and quotations only)
LEAD_TIME	NUMBER			Lead time for the price break (applies to RFQ's and quotations only)
LEAD_TIME_UNIT	VARCHAR2	(25)		Unit of measure for the lead time
PRICE_DISCOUNT	NUMBER			Discount percentage for price break (applies to RFQ's and quotations only)
TERMS_ID	NUMBER			Payment terms unique identifier
APPROVED_FLAG	VARCHAR2	(1)		Indicates whether the shipment is approved or not
APPROVED_DATE	DATE			Approval date for shipment (Unused since Version 6.0)
CLOSED_CODE	VARCHAR2	(30)		Indicates whether the shipment is closed or not
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the shipment is cancelled or not
CANCELLED_BY	NUMBER	(9)		Unique identifier of the employee who cancelled the shipment
CANCEL_DATE	DATE			Cancellation date
CANCEL_REASON	VARCHAR2	(240)		Cancellation reason provided by the employee
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(25)		Indicates whether the shipment is firmed or not
FIRM_DATE	DATE			Date the shipment becomes firmed
RECEIVING_ROUTING_ID	NUMBER			Receipt routing unique identifier
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether shipment must be inspected before the invoice is paid
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether shipment must be received before the invoice is paid
QTY_RCV_TOLERANCE	NUMBER			Maximum over-receipt tolerance percentage
QTY_RCV_EXCEPTION_CODE	VARCHAR2	(25)		Describes what action is taken when the quantity received tolerance is exceeded
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)		Describes what action is taken when the receiving location differs from the ship-to location
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	VARCHAR2	(1)		Indicates whether substitute items can be received in place of the ordered item
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received early
DAYS_LATE_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received late
RECEIPT_DAYS_EXCEPTION_CODE	VARCHAR2	(25)		Describes what action is taken when items are received earlier or later than the allowed number of days specified
SHIPMENT_NUM	NUMBER			Shipment line number
SOURCE_SHIPMENT_ID	NUMBER			Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment
SHIPMENT_TYPE	VARCHAR2	(25)	Yes	Type of the shipment
SHIP_TO_ORGANIZATION_ID	NUMBER			Unique identifier for the ship-to location
ACCRUE_ON_RECEIPT_FLAG	VARCHAR2	(1)		Indicates whether items are accrued on receipt
USSGL_TRANSACTION_CODE	VARCHAR2	(30)		United States standard general ledger transaction code
GOVERNMENT_CONTEXT	VARCHAR2	(30)		USSGL descriptive flexfield context column
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
TAX_CODE_ID	NUMBER
ORG_ID	NUMBER			Organization identifier

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT 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
FROM APPS.PO_OWNED_SHIPMENTS;

Dependencies

[top of page]

APPS.PO_OWNED_SHIPMENTS references the following:

APPS: PO_HEADERS_ALL; PO_LINE_LOCATIONS

APPS.PO_OWNED_SHIPMENTS is not referenced by any database object