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_LATE_RECEIPTS_V

Object Details

Object Name:	POS_PO_LATE_RECEIPTS_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PO.POS_PO_LATE_RECEIPTS_V POS.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	(91)		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)		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
CLM_FLAG	VARCHAR2	(1)		Clm Flag

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
,      CLM_FLAG
FROM APPS.POS_PO_LATE_RECEIPTS_V;

Dependencies

[top of page]

APPS.POS_PO_LATE_RECEIPTS_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; HR_ALL_ORGANIZATION_UNITS_TL; HR_LOCATIONS_ALL_TL; HZ_LOCATIONS; MTL_SYSTEM_ITEMS_KFV; PO_DOC_STYLE_HEADERS; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL

APPS.POS_PO_LATE_RECEIPTS_V is not referenced by any database object