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.PO_LINE_LOCATIONS_REF_V

Object Details

Object Name:	PO_LINE_LOCATIONS_REF_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_LINE_LOCATION_ID	NUMBER		Yes	Document shipment schedule unique identifier
PO_SHIPMENT_NUMBER	NUMBER			Shipment line number
TRX_FLOW_HEADER_ID	NUMBER			Transaction flow header identifier
DROP_SHIPMENT	VARCHAR2	(1)		Indicates whether the Shipment has a backing Sales Order Line.
SHIP_TO_ORGANIZATION_ID	NUMBER			Transaction flow header identifier
SHIP_TO_ORGANIZATION_CODE	VARCHAR2	(3)		Organization code
MATCH_OPTION	VARCHAR2	(25)		Indicator of whether the invoice for the shipment should be matched to the purchase order or the receipt
RECEIVING_ROUTING_ID	NUMBER			Receipt routing unique identifier
MATCH_APPROVAL_LEVEL	VARCHAR2	(4)		The Match Approval Level indicates what information will be compared to determine whether an invoice can be approved or not.Options are:2-Way,3-Way, 4-Way
DESCRIPTION	VARCHAR2	(240)		Pay Item description
POLL_ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield segment
POLL_ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
POLL_ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
POLL_GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Reserved for country-specific functionality
POLL_GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Reserved for country-specific functionality

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT PO_LINE_LOCATION_ID
,      PO_SHIPMENT_NUMBER
,      TRX_FLOW_HEADER_ID
,      DROP_SHIPMENT
,      SHIP_TO_ORGANIZATION_ID
,      SHIP_TO_ORGANIZATION_CODE
,      MATCH_OPTION
,      RECEIVING_ROUTING_ID
,      MATCH_APPROVAL_LEVEL
,      DESCRIPTION
,      POLL_ATTRIBUTE_CATEGORY
,      POLL_ATTRIBUTE1
,      POLL_ATTRIBUTE2
,      POLL_ATTRIBUTE3
,      POLL_ATTRIBUTE4
,      POLL_ATTRIBUTE5
,      POLL_ATTRIBUTE6
,      POLL_ATTRIBUTE7
,      POLL_ATTRIBUTE8
,      POLL_ATTRIBUTE9
,      POLL_ATTRIBUTE10
,      POLL_ATTRIBUTE11
,      POLL_ATTRIBUTE12
,      POLL_ATTRIBUTE13
,      POLL_ATTRIBUTE14
,      POLL_ATTRIBUTE15
,      POLL_GLOBAL_ATTRIBUTE_CATEGORY
,      POLL_GLOBAL_ATTRIBUTE1
,      POLL_GLOBAL_ATTRIBUTE2
,      POLL_GLOBAL_ATTRIBUTE3
,      POLL_GLOBAL_ATTRIBUTE4
,      POLL_GLOBAL_ATTRIBUTE5
,      POLL_GLOBAL_ATTRIBUTE6
,      POLL_GLOBAL_ATTRIBUTE7
,      POLL_GLOBAL_ATTRIBUTE8
,      POLL_GLOBAL_ATTRIBUTE9
,      POLL_GLOBAL_ATTRIBUTE10
,      POLL_GLOBAL_ATTRIBUTE11
,      POLL_GLOBAL_ATTRIBUTE12
,      POLL_GLOBAL_ATTRIBUTE13
,      POLL_GLOBAL_ATTRIBUTE14
,      POLL_GLOBAL_ATTRIBUTE15
,      POLL_GLOBAL_ATTRIBUTE16
,      POLL_GLOBAL_ATTRIBUTE17
,      POLL_GLOBAL_ATTRIBUTE18
,      POLL_GLOBAL_ATTRIBUTE19
,      POLL_GLOBAL_ATTRIBUTE20
FROM APPS.PO_LINE_LOCATIONS_REF_V;

Dependencies

[top of page]

APPS.PO_LINE_LOCATIONS_REF_V references the following:

APPS: MTL_PARAMETERS; PO_LINE_LOCATIONS

APPS.PO_LINE_LOCATIONS_REF_V is not referenced by any database object