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: ViewPO.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) Yes 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:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_GENERAL - show dependent code
SynonymHR_LOCATIONS_ALL
PL/SQL PackageHR_SECURITY - show dependent code
SynonymMTL_SYSTEM_ITEMS
ViewORG_ORGANIZATION_DEFINITIONS
PL/SQL PackagePOS_GET - show dependent code
SynonymPO_DOCUMENT_TYPES_ALL_TL
SynonymPO_HEADERS_ARCHIVE_ALL
SynonymPO_LINES_ARCHIVE_ALL
SynonymPO_LINE_LOCATIONS_ARCHIVE_ALL
SynonymPO_LINE_TYPES
ViewPO_LOOKUP_CODES
SynonymPO_RELEASES_ARCHIVE_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL
ViewRCV_ROUTING_HEADERS

APPS.POS_PO_LINES_ARCHIVE_V is not referenced by any database object