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_LINES_V

Object Details

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
ROW_ID	ROWID	(10)
PO_LINE_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes	Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATION_DATE	DATE			Standard who column - date when this row was created.
CREATED_BY	NUMBER			Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
REQUEST_ID	NUMBER			Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_APPLICATION_ID	NUMBER			Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_ID	NUMBER			Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_UPDATE_DATE	DATE			Concurrent Program who column - date when a program last updated this row).
PO_HEADER_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER
LINE_NUM	NUMBER		Yes
LINE_TYPE	VARCHAR2	(25)
ITEM_ID	NUMBER
ITEM_NUMBER	VARCHAR2	(40)
ITEM_REVISION	VARCHAR2	(3)
CATEGORY_ID	NUMBER
ITEM_DESCRIPTION	VARCHAR2	(240)
UNIT_MEAS_LOOKUP_CODE	VARCHAR2	(25)
QUANTITY_COMMITTED	NUMBER
COMMITTED_AMOUNT	NUMBER
ALLOW_PRICE_OVERRIDE_FLAG	VARCHAR2	(1)
NOT_TO_EXCEED_PRICE	NUMBER
LIST_PRICE_PER_UNIT	NUMBER
UNIT_PRICE	NUMBER
QUANTITY	NUMBER
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
UN_NUMBER_ID	NUMBER
UN_NUMBER	VARCHAR2	(25)
HAZARD_CLASS_ID	NUMBER
HAZARD_CLASS	VARCHAR2	(40)
MIN_ORDER_QUANTITY	NUMBER
MAX_ORDER_QUANTITY	NUMBER
QTY_RCV_TOLERANCE	NUMBER
OVER_TOLERANCE_ERROR_FLAG	VARCHAR2	(25)
MARKET_PRICE	NUMBER
UNORDERED_FLAG	VARCHAR2	(1)
CLOSED_FLAG	VARCHAR2	(1)
USER_HOLD_FLAG	VARCHAR2	(1)
CANCEL_FLAG	VARCHAR2	(1)
CANCELLED_BY	NUMBER	(9)
CANCEL_DATE	DATE
CANCEL_REASON	VARCHAR2	(240)
FIRM_STATUS_LOOKUP_CODE	VARCHAR2	(30)
FIRM_DATE	DATE
CONTRACT_NUM	VARCHAR2	(25)
NOTE_TO_VENDOR	VARCHAR2	(480)
FROM_HEADER_ID	NUMBER
FROM_LINE_ID	NUMBER
TAXABLE_FLAG	VARCHAR2	(1)
TAX_NAME	VARCHAR2	(0)
TYPE_1099	VARCHAR2	(10)
CAPITAL_EXPENSE_FLAG	VARCHAR2	(1)
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
MIN_RELEASE_AMOUNT	NUMBER
PRICE_TYPE_LOOKUP_CODE	VARCHAR2	(25)
PRICE_BREAK_LOOKUP_CODE	VARCHAR2	(25)
ALLOW_ITEM_DESC_UPDATE_FLAG	VARCHAR2	(1)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
OUTSIDE_OPERATION_FLAG	VARCHAR2	(1)
TRANSACTION_REASON_CODE	VARCHAR2	(25)
CLOSED_BY	NUMBER	(9)
CLOSED_DATE	DATE
CLOSED_CODE	VARCHAR2	(25)
CLOSED_REASON	VARCHAR2	(240)
GOVERNMENT_CONTEXT	VARCHAR2	(30)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
REFERENCE_NUM	VARCHAR2	(25)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)		Descriptive flexfield structure definition column.
ATTRIBUTE1	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE2	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE3	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE4	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE5	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE6	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE7	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE8	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE9	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE10	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE11	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE12	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE13	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE14	VARCHAR2	(150)		Descriptive flexfield segment
ATTRIBUTE15	VARCHAR2	(150)		Descriptive flexfield segment
EXTENDED_PRICE	NUMBER
PRIMARY_UNIT_CLASS	VARCHAR2	(10)
PRICE_TYPE	VARCHAR2	(80)
TRANSACTION_REASON	VARCHAR2	(80)
PLANNED_ITEM_FLAG	VARCHAR2	(1)
ALLOWED_UNITS_LOOKUP_CODE	NUMBER
OUTSIDE_OPERATION_UOM_TYPE	VARCHAR2	(25)
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)		Global Descriptive Flexfield Structure Defining column
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)		Global Descriptive Flexfield Segment
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)		Global Descriptive Flexfield Segment
EXPIRATION_DATE	DATE
TAX_CODE_ID	NUMBER
QC_GRADE	VARCHAR2	(25)
BASE_UOM	VARCHAR2	(25)
BASE_QTY	NUMBER
SECONDARY_UOM	VARCHAR2	(25)
SECONDARY_QTY	NUMBER
OKE_CONTRACT_HEADER_ID	NUMBER
OKE_CONTRACT_VERSION_ID	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
SECONDARY_QUANTITY	NUMBER
PREFERRED_GRADE	VARCHAR2	(150)
AUCTION_HEADER_ID	NUMBER			Sourcing Reference
AUCTION_DISPLAY_NUMBER	VARCHAR2	(40)		Sourcing Reference
AUCTION_LINE_NUMBER	NUMBER			Sourcing Reference
BID_NUMBER	NUMBER			Sourcing Reference
BID_LINE_NUMBER	NUMBER			Sourcing Reference
SUPPLIER_REF_NUMBER	VARCHAR2	(150)		Tracking code that links to a specific configuration of an item. Generated by a configuration engine maintained by suppliers.
CONTRACT_ID	NUMBER			Contract PA reference on a line. Apply to Standard PO only. Foreign to po_header_id in PO_HEADERS_ALL
JOB_ID	NUMBER			Reference to the HR Job
AMOUNT	NUMBER			This stores the Amount for the service line types
START_DATE	DATE			This stores the assignment start date for the contractor
CONTRACTOR_FIRST_NAME	VARCHAR2	(240)		Contractor First Name
CONTRACTOR_LAST_NAME	VARCHAR2	(240)		Contractor Last Name
PURCHASE_BASIS	VARCHAR2	(30)		Purchase basis for the line type
MATCHING_BASIS	VARCHAR2	(30)		Matching basis for the line type
FROM_LINE_LOCATION_ID	NUMBER			Unique identifier of the Price Break (standard POs only) referenced by this line. (References PO_LINE_LOCATIONS_ALL.line_location_id.)
BASE_UNIT_PRICE	NUMBER			Base Unit Price
MANUAL_PRICE_CHANGE_FLAG	VARCHAR2	(1)		Only for Standard PO lines referencing a Global Agreement, Contract, or Quotation: Y if the user has manually entered a price overriding the source document price, N or null otherwise.
TRACKING_SECONDARY_DEFAULT_IND	VARCHAR2	(30)
SECONDARY_UOM_CODE	VARCHAR2	(3)
GRADE_CONTROL_FLAG	VARCHAR2	(1)
ORG_ID	NUMBER			Organization identifier

Query Text

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


SELECT ROW_ID
,      PO_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      PO_HEADER_ID
,      LINE_TYPE_ID
,      LINE_NUM
,      LINE_TYPE
,      ITEM_ID
,      ITEM_NUMBER
,      ITEM_REVISION
,      CATEGORY_ID
,      ITEM_DESCRIPTION
,      UNIT_MEAS_LOOKUP_CODE
,      QUANTITY_COMMITTED
,      COMMITTED_AMOUNT
,      ALLOW_PRICE_OVERRIDE_FLAG
,      NOT_TO_EXCEED_PRICE
,      LIST_PRICE_PER_UNIT
,      UNIT_PRICE
,      QUANTITY
,      VENDOR_PRODUCT_NUM
,      UN_NUMBER_ID
,      UN_NUMBER
,      HAZARD_CLASS_ID
,      HAZARD_CLASS
,      MIN_ORDER_QUANTITY
,      MAX_ORDER_QUANTITY
,      QTY_RCV_TOLERANCE
,      OVER_TOLERANCE_ERROR_FLAG
,      MARKET_PRICE
,      UNORDERED_FLAG
,      CLOSED_FLAG
,      USER_HOLD_FLAG
,      CANCEL_FLAG
,      CANCELLED_BY
,      CANCEL_DATE
,      CANCEL_REASON
,      FIRM_STATUS_LOOKUP_CODE
,      FIRM_DATE
,      CONTRACT_NUM
,      NOTE_TO_VENDOR
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      TAXABLE_FLAG
,      TAX_NAME
,      TYPE_1099
,      CAPITAL_EXPENSE_FLAG
,      NEGOTIATED_BY_PREPARER_FLAG
,      MIN_RELEASE_AMOUNT
,      PRICE_TYPE_LOOKUP_CODE
,      PRICE_BREAK_LOOKUP_CODE
,      ALLOW_ITEM_DESC_UPDATE_FLAG
,      ORDER_TYPE_LOOKUP_CODE
,      OUTSIDE_OPERATION_FLAG
,      TRANSACTION_REASON_CODE
,      CLOSED_BY
,      CLOSED_DATE
,      CLOSED_CODE
,      CLOSED_REASON
,      GOVERNMENT_CONTEXT
,      USSGL_TRANSACTION_CODE
,      REFERENCE_NUM
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      EXTENDED_PRICE
,      PRIMARY_UNIT_CLASS
,      PRICE_TYPE
,      TRANSACTION_REASON
,      PLANNED_ITEM_FLAG
,      ALLOWED_UNITS_LOOKUP_CODE
,      OUTSIDE_OPERATION_UOM_TYPE
,      GLOBAL_ATTRIBUTE_CATEGORY
,      GLOBAL_ATTRIBUTE1
,      GLOBAL_ATTRIBUTE2
,      GLOBAL_ATTRIBUTE3
,      GLOBAL_ATTRIBUTE4
,      GLOBAL_ATTRIBUTE5
,      GLOBAL_ATTRIBUTE6
,      GLOBAL_ATTRIBUTE7
,      GLOBAL_ATTRIBUTE8
,      GLOBAL_ATTRIBUTE9
,      GLOBAL_ATTRIBUTE10
,      GLOBAL_ATTRIBUTE11
,      GLOBAL_ATTRIBUTE12
,      GLOBAL_ATTRIBUTE13
,      GLOBAL_ATTRIBUTE14
,      GLOBAL_ATTRIBUTE15
,      GLOBAL_ATTRIBUTE16
,      GLOBAL_ATTRIBUTE17
,      GLOBAL_ATTRIBUTE18
,      GLOBAL_ATTRIBUTE19
,      GLOBAL_ATTRIBUTE20
,      EXPIRATION_DATE
,      TAX_CODE_ID
,      QC_GRADE
,      BASE_UOM
,      BASE_QTY
,      SECONDARY_UOM
,      SECONDARY_QTY
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      SECONDARY_UNIT_OF_MEASURE
,      SECONDARY_QUANTITY
,      PREFERRED_GRADE
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      SUPPLIER_REF_NUMBER
,      CONTRACT_ID
,      JOB_ID
,      AMOUNT
,      START_DATE
,      CONTRACTOR_FIRST_NAME
,      CONTRACTOR_LAST_NAME
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      FROM_LINE_LOCATION_ID
,      BASE_UNIT_PRICE
,      MANUAL_PRICE_CHANGE_FLAG
,      TRACKING_SECONDARY_DEFAULT_IND
,      SECONDARY_UOM_CODE
,      GRADE_CONTROL_FLAG
,      ORG_ID
FROM APPS.PO_LINES_V;

Dependencies

[top of page]

APPS.PO_LINES_V references the following:

APPS: FND_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS; MTL_UNITS_OF_MEASURE; PO_HAZARD_CLASSES_TL; PO_LINES; PO_LINES_SV4 - show dependent code; PO_LINE_TYPES_B; PO_LINE_TYPES_TL; PO_LOOKUP_CODES; PO_UN_NUMBERS_TL

APPS.PO_LINES_V is referenced by following:

APPS: GHG_PO_EMISSIONS_PKG - show dependent code