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

VIEW: APPS.POS_PO_DETAILS_V

Object Details
Object Name: POS_PO_DETAILS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewPO.POS_PO_DETAILS_V
Subobject Name:
Status: VALID

View Type

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


Fetches all the information related to a purchase order


[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 unique identifier
CREATION_DATE DATE

Standard Who Column
QUANTITY VARCHAR2 (40)
Quantity ordered or break quantity for blanket purchase orders, RFQs and quotations
QUANTITY_REJECTED NUMBER

Quantity rejected after inspection, up until today
SHIP_TO_LOCATION_ID NUMBER

Ship to location unique identifier
NEED_BY_DATE DATE

Need-by date for the shipment schedule
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
CLOSED_CODE VARCHAR2 (30)
Closure status of the shipment
CLOSED_DATE DATE

Closure date of the shipment
CLOSED_REASON VARCHAR2 (240)
Why the shipment is closed
SHIPMENT_NUM NUMBER

Shipment line number
DAYS_LATE_RECEIPT_ALLOWED NUMBER

Maximum acceptable number of days items can be received early
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 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
MATCHING_TYPE VARCHAR2 (5)
Indicates whether shipment must be inspected before the invoice is paid
SHIP_TO_ORGANIZATION_ID NUMBER

Ship to organization unique identifier
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 (9)
Unique identifier of employee who closed the shipment
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 (9)
Unique identifier of employee who cancelled the shipment
CANCEL_DATE DATE

cancel date of the shipment
CANCEL_REASON VARCHAR2 (240)
cancel reason of the shipment
LINE_LOCATION_ID NUMBER
Yes Document shipment schedule unique identifier
PO_HEADER_ID NUMBER
Yes Document unique identifier
CREATED_BY NUMBER

Standard Who COlumn
QUANTITY_RECEIVED NUMBER

Quantity received until today
QUANTITY_ACCEPTED NUMBER

Quantity accepted after inspection, up until today
QUANTITY_BILLED NUMBER

Quantity invoiced by Oracle Payables, up until today
QUANTITY_CANCELLED NUMBER

Quantity cancelled
PO_RELEASE_ID NUMBER

Release unique identifier
PROMISED_DATE DATE

Supplier promised delivery date
TAXABLE_FLAG VARCHAR2 (1)
Indicates whether the shipment is taxable
TAX_NAME VARCHAR2 (15)
Tax code for the shipment
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
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)
Name of employee who cancelled the shipment
CLOSED_BY_NAME VARCHAR2 (4000)
Name of employee who closed the shipment
PO_NUM VARCHAR2 (20) Yes Document Number
TYPE_LOOKUP_CODE VARCHAR2 (25) Yes Document Code
RELEASE_NUM NUMBER

Release Number
RELEASE_TYPE VARCHAR2 (25)
Release Type
AGENT_ID NUMBER

Agent unique identifier
AGENT_NAME VARCHAR2 (4000)
Agent 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)
Currnecy Code
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization status of the purchase order
REVISION_NUM NUMBER

Document Revision Number
ORDER_DATE DATE

Order Date
APPROVED_DATE DATE

Approved Date
REVISED_DATE VARCHAR2 (9)
Date the document was last revised
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier to be used
RATE_TYPE VARCHAR2 (30)
Currency conversion rate type
RATE_DATE DATE

Currency conversion date
RATE NUMBER

Currency conversion rate
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Indicates whether the purchase order is a confirming order or not
ACCEPTANCE_DUE_DATE DATE

Date by which the supplier should accept the purchase order
LINE_NUM NUMBER
Yes Document Line Number
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 Short Note
VENDOR_PRODUCT_NUM VARCHAR2 (25)
Supplier product number
SHIPMENT_AMOUNT NUMBER

Shipment Amount
ITEM_URL VARCHAR2 (240)
Itm URL
SUPPLIER_URL VARCHAR2 (150)
Supplier URL
ITEM_NUM VARCHAR2 (40)
Item Number
PRICE_BREAK_QUANTITY NUMBER

Price break Quantity
BREAK_PRICE NUMBER

Price Break
PRICE_DISCOUNT NUMBER

Discount on price
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location Code
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
,      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
,      ORDER_DATE
,      APPROVED_DATE
,      REVISED_DATE
,      SHIP_VIA_LOOKUP_CODE
,      RATE_TYPE
,      RATE_DATE
,      RATE
,      CONFIRMING_ORDER_FLAG
,      ACCEPTANCE_DUE_DATE
,      LINE_NUM
,      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
,      SHIPMENT_AMOUNT
,      ITEM_URL
,      SUPPLIER_URL
,      ITEM_NUM
,      PRICE_BREAK_QUANTITY
,      BREAK_PRICE
,      PRICE_DISCOUNT
,      SHIP_TO_LOCATION
FROM APPS.POS_PO_DETAILS_V;

Dependencies

[top of page]

APPS.POS_PO_DETAILS_V references the following:

SchemaAPPS
SynonymAP_TAX_CODES
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymHR_LOCATIONS_ALL
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_HEADERS_ALL
PL/SQL PackagePO_INQ_SV - show dependent code
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_DETAILS_V is not referenced by any database object