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

VIEW: APPS.POS_PO_LATE_RECEIPTS_V

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

View Type

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


This View displays all receipts which has passed the Promised Date on the Purchase Orders for all Organizations


[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
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 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)
Closed Code
CLOSED_DATE DATE

Closure Date
CLOSED_REASON VARCHAR2 (240)
Closure 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)
Maximum acceptable number of days items can be received late
INSPECTION_REQUIRED_FLAG VARCHAR2 (1)
Indicates whether inspection is required or not
RECEIPT_REQUIRED_FLAG VARCHAR2 (1)
indicates whether receipt is required or not
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
APPROVED_FLAG VARCHAR2 (1)
Indicates whether Document is approved or not
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
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

Document Release Unique identifier
PROMISED_DATE DATE

Promised date on the shipment
TAXABLE_FLAG VARCHAR2 (1)
indicates whether shipment is taxable or not
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
SHIP_TO_LOCATION VARCHAR2 (60)
Ship to location
PO_NUM VARCHAR2 (61)
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 (0)
Employee Name
VENDOR_ID NUMBER

Supplier Unique identifier
VENDOR_NAME VARCHAR2 (240)
Supplier Name
VENDOR_NUMBER VARCHAR2 (30) Yes Vendor Number
VENDOR_SITE_ID NUMBER

Supplier Site Unique identifier
VENDOR_SITE_CODE VARCHAR2 (15) Yes Supplier Site
VENDOR_CONTACT VARCHAR2 (32)
Supplier Contact
CURRENCY_CODE VARCHAR2 (15)
Currency Code of the Purchase Order
AUTHORIZATION_STATUS VARCHAR2 (25)
Authorization Ststus of the document
REVISION_NUM NUMBER

Revision Number
DOC_TYPE_NAME VARCHAR2 (0)
Document Type Name
ORDER_DATE DATE

Creation date
APPROVED_DATE DATE

Approval Date
REVISED_DATE VARCHAR2 (9)
Date of Revision
SHIP_VIA_LOOKUP_CODE VARCHAR2 (25)
Type of carrier to be used
RATE_TYPE VARCHAR2 (30)
Conversion Rate Type
RATE_DATE DATE

Conversion Rate Date
RATE NUMBER

Conversion Rate
CONFIRMING_ORDER_FLAG VARCHAR2 (1)
Indicates whether document is conforming
ACCEPTANCE_DUE_DATE DATE

Due date of Acceptance of the Document
LINE_NUM NUMBER

Document Line Number
LINE_TYPE VARCHAR2 (25) Yes Document Line Type
ITEM_ID NUMBER

Item Unique identifier
ITEM_REVISION VARCHAR2 (3)
Item Revision
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 if proce override is allowed
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 type of outside operation
SHIPMENT_AMOUNT NUMBER

Total Amount of Shipment
ITEM_URL VARCHAR2 (240)
Item Info URL
SUPPLIER_URL VARCHAR2 (150)
Supplier Infor URL
ITEM_NUM VARCHAR2 (40)
Item Number
ORG_ID NUMBER

organization Id
ORG_NAME VARCHAR2 (240)
Organization Name
SUPPLIER_REF_NUMBER VARCHAR2 (150)
Configuration Id
PROMISED_DATETIME DATE

Promised Datetime
QUANTITY_SHIPPED NUMBER

Quantity Shipped
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
,      SHIP_TO_ORGANIZATION_ID
,      RECEIPT_DAYS_EXCEPTION_CODE
,      APPROVED_FLAG
,      LINE_LOCATION_ID
,      PO_HEADER_ID
,      CREATED_BY
,      QUANTITY_RECEIVED
,      QUANTITY_ACCEPTED
,      QUANTITY_BILLED
,      QUANTITY_CANCELLED
,      PO_RELEASE_ID
,      PROMISED_DATE
,      TAXABLE_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      SHIP_TO_LOCATION
,      PO_NUM
,      TYPE_LOOKUP_CODE
,      RELEASE_NUM
,      RELEASE_TYPE
,      AGENT_ID
,      AGENT_NAME
,      VENDOR_ID
,      VENDOR_NAME
,      VENDOR_NUMBER
,      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
,      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
,      ORG_ID
,      ORG_NAME
,      SUPPLIER_REF_NUMBER
,      PROMISED_DATETIME
,      QUANTITY_SHIPPED
FROM APPS.POS_PO_LATE_RECEIPTS_V;

Dependencies

[top of page]

APPS.POS_PO_LATE_RECEIPTS_V references the following:

SchemaAPPS
SynonymFINANCIALS_SYSTEM_PARAMS_ALL
SynonymHR_ALL_ORGANIZATION_UNITS_TL
SynonymHR_LOCATIONS_ALL_TL
SynonymHZ_LOCATIONS
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_HEADERS_ALL
SynonymPO_LINES_ALL
SynonymPO_LINE_LOCATIONS_ALL
SynonymPO_LINE_TYPES
SynonymPO_RELEASES_ALL
ViewPO_VENDORS
ViewPO_VENDOR_CONTACTS
ViewPO_VENDOR_SITES_ALL

APPS.POS_PO_LATE_RECEIPTS_V is not referenced by any database object