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_V

Object Details

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

View Type

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

Fetches information related to shipments for the Purchase Order. Used to fetch records for which an ASN could be created.

[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	NUMBER			Quantity Ordered
QUANTITY_REJECTED	NUMBER			Quantity Rejected
SHIP_TO_LOCATION_ID	NUMBER			Ship to location
NEED_BY_DATE	DATE			Need by date of Shipment
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	(30)		Closed Code
CLOSED_DATE	DATE			Closed 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)		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)		Matching Type
SHIP_TO_ORGANIZATION_ID	NUMBER			Ship to organization Id
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)		Closed By
APPROVED_FLAG	VARCHAR2	(1)		Approved or not
CLOSED_FLAG	VARCHAR2	(1)		Closed Flag
CANCEL_FLAG	VARCHAR2	(1)		Cancel Flag
CANCELLED_BY	NUMBER	(9)		Cancelled by employee name
CANCEL_DATE	DATE			Cancel date
CANCEL_REASON	VARCHAR2	(240)		Cancel reason
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 Relase unique identifier
PROMISED_DATE	DATE			Promised date on shipment
TAXABLE_FLAG	VARCHAR2	(1)		Indicated 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 Name
SOURCE_SHIPMENT_NUM	NUMBER			Document Number of the planned purchase order shipment that was referenced when creating this scheduled release shipment
CANCELLED_BY_NAME	VARCHAR2	(4000)		Cancelled by Employee
CLOSED_BY_NAME	VARCHAR2	(4000)		Closed by employee
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	(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 Name
CURRENCY_CODE	VARCHAR2	(15)		Currency Code
AUTHORIZATION_STATUS	CHAR	(8)		Authorization status of the document
REVISION_NUM	NUMBER			Revision Number
DOC_TYPE_NAME	VARCHAR2	(80)		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)		Carrier type to be used
FOB_DSP	VARCHAR2	(80)		Displayed Field
FREIGHT_TERMS_DSP	VARCHAR2	(80)		Displayed Field
RATE_TYPE	VARCHAR2	(30)		Currency Conversion 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			Due date of acceptance
LINE_NUM	NUMBER		Yes	Document Line Number
LINE_TYPE	VARCHAR2	(25)		Document LIne Type
ITEM_ID	NUMBER			Item Unique identifier
ITEM_REVISION	VARCHAR2	(3)		Item Revison Number
ITEM_DESCRIPTION	VARCHAR2	(240)		Item Description
CATEGORY_ID	NUMBER			Category unique identifier
CONTRACT_NUM	VARCHAR2	(25)		Contract number referenced
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)		Short Note to Supplier
VENDOR_PRODUCT_NUM	VARCHAR2	(25)		Supplier Product Number
OUTSIDE_OPERATION_UOM_TYPE	VARCHAR2	(1)		Uom of outside operation
SHIPMENT_AMOUNT	NUMBER			Shipment Amount
ITEM_URL	VARCHAR2	(240)		Item Info URL
SUPPLIER_URL	VARCHAR2	(150)		Supplier Info URL
ITEM_NUM	VARCHAR2	(40)		Item Number
PRICE_BREAK_QUANTITY	NUMBER			price break quantity on blanket
BREAK_PRICE	NUMBER			price break on blanket
PRICE_DISCOUNT	NUMBER			price discount on blanket

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
,      PRICE_BREAK_QUANTITY
,      BREAK_PRICE
,      PRICE_DISCOUNT
FROM APPS.POS_PO_LINES_V;

Dependencies

[top of page]

APPS.POS_PO_LINES_V references the following:

APPS: FINANCIALS_SYSTEM_PARAMS_ALL; FND_GLOBAL - show dependent code; HR_GENERAL - show dependent code; HR_LOCATIONS_ALL; HR_ORGANIZATION_UNITS; HR_SECURITY - show dependent code; MTL_SYSTEM_ITEMS_KFV; POS_GET - show dependent code; PO_DOCUMENT_TYPES_ALL_VL; PO_HEADERS_ALL; PO_LINES_ALL; PO_LINE_LOCATIONS_ALL; PO_LINE_TYPES; PO_LOOKUP_CODES; PO_RELEASES_ALL; PO_VENDORS; PO_VENDOR_CONTACTS; PO_VENDOR_SITES_ALL; RCV_ROUTING_HEADERS

APPS.POS_PO_LINES_V is not referenced by any database object