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.POS_PO_LINES_ARCHIVE_V

Object Details

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

View Type

A public view which may be useful for custom reporting or other data
requirements.

Fetches information from the po_lines_archive_all table. Needed to show Purchase Order History information.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
DAYS_EARLY_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received early
PO_LINE_ID	NUMBER		Yes	Document Line Number unique identifier
CREATION_DATE	DATE			Standard Who Column
QUANTITY	NUMBER			Quantity Ordered
QUANTITY_REJECTED	NUMBER			Quantity Rejected
SHIP_TO_LOCATION_ID	NUMBER			Ship to location
NEED_BY_DATE	DATE			Need by date on the Document line
LAST_ACCEPT_DATE	DATE			Last date of acceptance
PRICE_OVERRIDE	NUMBER			Order shipment price or break price for blanket purchase orders, RFQs, and quotations
CLOSED_CODE	VARCHAR2	(25)		Closed Code
CLOSED_DATE	DATE			Closed Date
CLOSED_REASON	VARCHAR2	(240)		Closed Reason
SHIPMENT_NUM	NUMBER			Shipment Number
DAYS_LATE_RECEIPT_ALLOWED	NUMBER			Maximum acceptable number of days items can be received late
ENFORCE_SHIP_TO_LOCATION_CODE	VARCHAR2	(25)		Describes what action is taken when the receiving location differs from the ship-to location
INSPECTION_REQUIRED_FLAG	VARCHAR2	(1)		Indicates whether inspection is required or not
RECEIPT_REQUIRED_FLAG	VARCHAR2	(1)		indicates whether inspection is required or not
MATCHING_TYPE	VARCHAR2	(5)		Matching Type
SHIP_TO_ORGANIZATION_ID	NUMBER			Ship to Organization
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
CLOSED_BY	NUMBER			Closed by employee
APPROVED_FLAG	VARCHAR2	(1)		Indicates whether the shipment is approved
CLOSED_FLAG	VARCHAR2	(1)		Indicates whether the shipment is closed
CANCEL_FLAG	VARCHAR2	(1)		Indicates whether the shipment is cancelled
CANCELLED_BY	NUMBER			Cancelled by employee
CANCEL_DATE	DATE			Cancel Date
CANCEL_REASON	VARCHAR2	(240)		Reason of cancellation
LINE_LOCATION_ID	NUMBER		Yes	Shipment unique identifier
PO_HEADER_ID	NUMBER		Yes	Document unique identifier
CREATED_BY	NUMBER			Standard Who column
QUANTITY_RECEIVED	NUMBER			Quantity Received
QUANTITY_ACCEPTED	NUMBER			Quantity Accepted
QUANTITY_BILLED	NUMBER			Quantity Billed
QUANTITY_CANCELLED	NUMBER			Quantity Cancelled
PO_RELEASE_ID	NUMBER			Document Release Unique identifier
PROMISED_DATE	DATE			Promised date on shipment
TAXABLE_FLAG	VARCHAR2	(1)		indicates whether shipment is taxable
TAX_NAME	CHAR	(0)		Tax name
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive Flex Field
ATTRIBUTE1	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE2	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE3	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE4	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE5	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE6	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE7	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE8	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE9	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE10	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE11	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE12	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE13	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE14	VARCHAR2	(150)		Descriptive Flex Field
ATTRIBUTE15	VARCHAR2	(150)		Descriptive Flex Field
ROUTING_NAME	VARCHAR2	(80)		Receipt routing Name
RECEIPT_DAYS_EXCEPTION	VARCHAR2	(80)		Describes what action is taken when items are received earlier or later than the allowed number of days specified
QTY_RCV_EXCEPTION	VARCHAR2	(80)		Describes what action is taken when the quantity received tolerance is exceeded
CLOSED_CODE_DSP	VARCHAR2	(80)	Yes	Displayed Field
SHIP_TO_LOCATION	VARCHAR2	(60)		Ship to location
SHIP_TO_ORGANIZATION	VARCHAR2	(240)		Ship to organization
SOURCE_SHIPMENT_NUM	NUMBER			Unique identifier of the planned purchase order shipment that was referenced when creating this scheduled release shipment
CANCELLED_BY_NAME	VARCHAR2	(4000)		Employee name who cancelled the Purchase order
CLOSED_BY_NAME	VARCHAR2	(4000)		Employee name who closed the Purchase order
PO_NUM	VARCHAR2	(20)	Yes	Document Number
TYPE_LOOKUP_CODE	VARCHAR2	(25)	Yes	Document Type
RELEASE_NUM	NUMBER			Release Number
RELEASE_TYPE	VARCHAR2	(25)		Release Type
AGENT_ID	NUMBER			Employee id
AGENT_NAME	VARCHAR2	(4000)		Employee name
VENDOR_ID	NUMBER			Supplier unique identifier
VENDOR_NAME	VARCHAR2	(240)		Supplier Name
VENDOR_SITE_ID	NUMBER			Supplier Site unique identifier
VENDOR_SITE_CODE	VARCHAR2	(15)		Supplier Site Code
VENDOR_CONTACT	VARCHAR2	(32)		Supplier Contact
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
AUTHORIZATION_STATUS	VARCHAR2	(25)		Authorization status of the Document
REVISION_NUM	NUMBER			revison Number
DOC_TYPE_NAME	VARCHAR2	(80)		Document Type Name
ORDER_DATE	DATE			Creation Date
APPROVED_DATE	DATE			Approved Date
REVISED_DATE	VARCHAR2	(9)		Date of Revision
SHIP_VIA_LOOKUP_CODE	VARCHAR2	(25)		Carrier type to be used
FOB_DSP	VARCHAR2	(80)		Displayed Field
FREIGHT_TERMS_DSP	VARCHAR2	(80)		Displayed Field
RATE_TYPE	VARCHAR2	(30)		Conversion Type
RATE_DATE	DATE			Conversion Date
RATE	NUMBER			Conversion Rate
CONFIRMING_ORDER_FLAG	VARCHAR2	(1)		Indicates whether the purchase order is a confirming order
ACCEPTANCE_DUE_DATE	DATE			Acceptance Due Date
LINE_NUM	NUMBER		Yes	Document Line Number
LINE_TYPE	VARCHAR2	(25)	Yes	Document Line Type
ITEM_ID	NUMBER			Item unique identifier
ITEM_REVISION	VARCHAR2	(3)		Item Revision Number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
CATEGORY_ID	NUMBER			Category Unique identifier
CONTRACT_NUM	VARCHAR2	(25)		Contract number referenced on the line
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)		Unit of measure lookup code
ALLOW_PRICE_OVERRIDE_FLAG	VARCHAR2	(1)		Indicates whether or not you can change the price on releases
NOT_TO_EXCEED_PRICE	NUMBER			Price limit that you cannot exceed on a release shipment
NOTE_TO_VENDOR	VARCHAR2	(480)		Supplier Note
VENDOR_PRODUCT_NUM	VARCHAR2	(25)		Supplier Product Number
OUTSIDE_OPERATION_UOM_TYPE	VARCHAR2	(1)		Unit of measure of outisde operation
SHIPMENT_AMOUNT	NUMBER			Shipment Amount
ITEM_URL	VARCHAR2	(240)		Item Info URL
SUPPLIER_URL	VARCHAR2	(150)		Supplier Info URL
ITEM_NUM	VARCHAR2	(4000)		Item Number

Query Text

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


SELECT DAYS_EARLY_RECEIPT_ALLOWED
,      PO_LINE_ID
,      CREATION_DATE
,      QUANTITY
,      QUANTITY_REJECTED
,      SHIP_TO_LOCATION_ID
,      NEED_BY_DATE
,      LAST_ACCEPT_DATE
,      PRICE_OVERRIDE
,      CLOSED_CODE
,      CLOSED_DATE
,      CLOSED_REASON
,      SHIPMENT_NUM
,      DAYS_LATE_RECEIPT_ALLOWED
,      ENFORCE_SHIP_TO_LOCATION_CODE
,      INSPECTION_REQUIRED_FLAG
,      RECEIPT_REQUIRED_FLAG
,      MATCHING_TYPE
,      SHIP_TO_ORGANIZATION_ID
,      RECEIPT_DAYS_EXCEPTION_CODE
,      CLOSED_BY
,      APPROVED_FLAG
,      CLOSED_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      LINE_LOCATION_ID
,      PO_HEADER_ID
,      CREATED_BY
,      QUANTITY_RECEIVED
,      QUANTITY_ACCEPTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      PO_RELEASE_ID
,      PROMISED_DATE
,      TAXABLE_FLAG
,      TAX_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ROUTING_NAME
,      RECEIPT_DAYS_EXCEPTION
,      QTY_RCV_EXCEPTION
,      CLOSED_CODE_DSP
,      SHIP_TO_LOCATION
,      SHIP_TO_ORGANIZATION
,      SOURCE_SHIPMENT_NUM
,      CANCELLED_BY_NAME
,      CLOSED_BY_NAME
,      PO_NUM
,      TYPE_LOOKUP_CODE
,      RELEASE_NUM
,      RELEASE_TYPE
,      AGENT_ID
,      AGENT_NAME
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_SITE_ID
,      VENDOR_SITE_CODE
,      VENDOR_CONTACT
,      CURRENCY_CODE
,      AUTHORIZATION_STATUS
,      REVISION_NUM
,      DOC_TYPE_NAME
,      ORDER_DATE
,      APPROVED_DATE
,      REVISED_DATE
,      SHIP_VIA_LOOKUP_CODE
,      FOB_DSP
,      FREIGHT_TERMS_DSP
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CONFIRMING_ORDER_FLAG
,      ACCEPTANCE_DUE_DATE
,      LINE_NUM
,      LINE_TYPE
,      ITEM_ID
,      ITEM_REVISION
,      ITEM_DESCRIPTION
,      CATEGORY_ID
,      CONTRACT_NUM
,      UNIT_MEAS_LOOKUP_CODE
,      ALLOW_PRICE_OVERRIDE_FLAG
,      NOT_TO_EXCEED_PRICE
,      NOTE_TO_VENDOR
,      VENDOR_PRODUCT_NUM
,      OUTSIDE_OPERATION_UOM_TYPE
,      SHIPMENT_AMOUNT
,      ITEM_URL
,      SUPPLIER_URL
,      ITEM_NUM
FROM APPS.POS_PO_LINES_ARCHIVE_V;

Dependencies

[top of page]

APPS.POS_PO_LINES_ARCHIVE_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS; ORG_ORGANIZATION_DEFINITIONS; POS_GET - show dependent code; PO_DOCUMENT_TYPES_ALL_TL; PO_HEADERS_ARCHIVE_ALL; PO_LINES_ARCHIVE_ALL; PO_LINE_LOCATIONS_ARCHIVE_ALL; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_RELEASES_ARCHIVE_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS

APPS.POS_PO_LINES_ARCHIVE_V is not referenced by any database object