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_TRX_V

Object Details

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

View Type

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

PO Lines View.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
PO_LINE_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
PO_HEADER_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER
LINE_NUM	VARCHAR2	(240)
LAST_UPDATE_LOGIN	NUMBER			Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_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).
ITEM_ID	NUMBER
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
UN_NUMBER_ID	NUMBER
HAZARD_CLASS_ID	NUMBER
NOTE_TO_VENDOR	VARCHAR2	(480)
FROM_HEADER_ID	NUMBER
FROM_LINE_ID	NUMBER
FROM_LINE_LOCATION_ID	NUMBER
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
VENDOR_PRODUCT_NUM	VARCHAR2	(25)
CONTRACT_NUM	VARCHAR2	(25)
TAXABLE_FLAG	VARCHAR2	(1)
TAX_NAME	VARCHAR2	(30)
TYPE_1099	VARCHAR2	(10)
CAPITAL_EXPENSE_FLAG	VARCHAR2	(1)
NEGOTIATED_BY_PREPARER_FLAG	VARCHAR2	(1)
ATTRIBUTE_CATEGORY	VARCHAR2	(30)
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
REFERENCE_NUM	VARCHAR2	(25)
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)
MIN_RELEASE_AMOUNT	NUMBER
PRICE_TYPE_LOOKUP_CODE	VARCHAR2	(25)
CLOSED_CODE	VARCHAR2	(25)
PRICE_BREAK_LOOKUP_CODE	VARCHAR2	(25)
USSGL_TRANSACTION_CODE	VARCHAR2	(30)
GOVERNMENT_CONTEXT	VARCHAR2	(30)
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).
CLOSED_DATE	DATE
CLOSED_REASON	VARCHAR2	(240)
CLOSED_BY	NUMBER	(9)
TRANSACTION_REASON_CODE	VARCHAR2	(25)
ORG_ID	NUMBER			Organization identifier
QC_GRADE	VARCHAR2	(25)
BASE_UOM	VARCHAR2	(25)
BASE_QTY	NUMBER
SECONDARY_UOM	VARCHAR2	(25)
SECONDARY_QTY	NUMBER
GLOBAL_ATTRIBUTE_CATEGORY	VARCHAR2	(150)
GLOBAL_ATTRIBUTE1	VARCHAR2	(150)
GLOBAL_ATTRIBUTE2	VARCHAR2	(150)
GLOBAL_ATTRIBUTE3	VARCHAR2	(150)
GLOBAL_ATTRIBUTE4	VARCHAR2	(150)
GLOBAL_ATTRIBUTE5	VARCHAR2	(150)
GLOBAL_ATTRIBUTE6	VARCHAR2	(150)
GLOBAL_ATTRIBUTE7	VARCHAR2	(150)
GLOBAL_ATTRIBUTE8	VARCHAR2	(150)
GLOBAL_ATTRIBUTE9	VARCHAR2	(150)
GLOBAL_ATTRIBUTE10	VARCHAR2	(150)
GLOBAL_ATTRIBUTE11	VARCHAR2	(150)
GLOBAL_ATTRIBUTE12	VARCHAR2	(150)
GLOBAL_ATTRIBUTE13	VARCHAR2	(150)
GLOBAL_ATTRIBUTE14	VARCHAR2	(150)
GLOBAL_ATTRIBUTE15	VARCHAR2	(150)
GLOBAL_ATTRIBUTE16	VARCHAR2	(150)
GLOBAL_ATTRIBUTE17	VARCHAR2	(150)
GLOBAL_ATTRIBUTE18	VARCHAR2	(150)
GLOBAL_ATTRIBUTE19	VARCHAR2	(150)
GLOBAL_ATTRIBUTE20	VARCHAR2	(150)
LINE_REFERENCE_NUM	VARCHAR2	(25)
PROJECT_ID	NUMBER
TASK_ID	NUMBER
EXPIRATION_DATE	DATE
TAX_CODE_ID	NUMBER
OKE_CONTRACT_HEADER_ID	NUMBER
OKE_CONTRACT_VERSION_ID	NUMBER
SECONDARY_QUANTITY	NUMBER
SECONDARY_UNIT_OF_MEASURE	VARCHAR2	(25)
PREFERRED_GRADE	VARCHAR2	(150)
AUCTION_HEADER_ID	NUMBER
AUCTION_DISPLAY_NUMBER	VARCHAR2	(40)
AUCTION_LINE_NUMBER	NUMBER
BID_NUMBER	NUMBER
BID_LINE_NUMBER	NUMBER
RETROACTIVE_DATE	DATE
SUPPLIER_REF_NUMBER	VARCHAR2	(150)
CONTRACT_ID	NUMBER
START_DATE	DATE
AMOUNT	NUMBER
JOB_ID	NUMBER
CONTRACTOR_FIRST_NAME	VARCHAR2	(240)
CONTRACTOR_LAST_NAME	VARCHAR2	(240)
ORDER_TYPE_LOOKUP_CODE	VARCHAR2	(25)
PURCHASE_BASIS	VARCHAR2	(30)
MATCHING_BASIS	VARCHAR2	(30)
SVC_AMOUNT_NOTIF_SENT	VARCHAR2	(1)
SVC_COMPLETION_NOTIF_SENT	VARCHAR2	(1)
BASE_UNIT_PRICE	NUMBER
MANUAL_PRICE_CHANGE_FLAG	VARCHAR2	(1)
RETAINAGE_RATE	NUMBER
MAX_RETAINAGE_AMOUNT	NUMBER
PROGRESS_PAYMENT_RATE	NUMBER
RECOUPMENT_RATE	NUMBER
CATALOG_NAME	VARCHAR2	(255)
SUPPLIER_PART_AUXID	VARCHAR2	(255)
IP_CATEGORY_ID	NUMBER
TAX_ATTRIBUTE_UPDATE_CODE	VARCHAR2	(15)
LAST_UPDATED_PROGRAM	VARCHAR2	(255)
GROUP_LINE_ID	NUMBER
LINE_NUM_DISPLAY	VARCHAR2	(240)
CLM_INFO_FLAG	VARCHAR2	(1)
CLM_OPTION_INDICATOR	VARCHAR2	(1)
CLM_BASE_LINE_NUM	NUMBER
CLM_OPTION_NUM	NUMBER
CLM_OPTION_FROM_DATE	DATE
CLM_OPTION_TO_DATE	DATE
CLM_FUNDED_FLAG	VARCHAR2	(1)
CONTRACT_TYPE	VARCHAR2	(240)
COST_CONSTRAINT	VARCHAR2	(240)
CLM_IDC_TYPE	VARCHAR2	(240)
UDA_TEMPLATE_ID	NUMBER
USER_DOCUMENT_STATUS	VARCHAR2	(30)
DRAFT_ID	NUMBER
LINE_NUM_DISP	VARCHAR2	(240)
CLM_MIN_TOTAL_AMOUNT	NUMBER
CLM_MAX_TOTAL_AMOUNT	NUMBER
CLM_MIN_TOTAL_QUANTITY	NUMBER
CLM_MAX_TOTAL_QUANTITY	NUMBER
CLM_MIN_ORDER_AMOUNT	NUMBER
CLM_MAX_ORDER_AMOUNT	NUMBER
CLM_MIN_ORDER_QUANTITY	NUMBER
CLM_MAX_ORDER_QUANTITY	NUMBER
CLM_TOTAL_AMOUNT_ORDERED	NUMBER
CLM_TOTAL_QUANTITY_ORDERED	NUMBER
CLM_FSC_PSC	VARCHAR2	(200)
CLM_MDAPS_MAIS	VARCHAR2	(200)
CLM_NAICS	VARCHAR2	(200)
CLM_ORDER_START_DATE	DATE
CLM_ORDER_END_DATE	DATE

Query Text

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


SELECT PO_LINE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      PO_HEADER_ID
,      LINE_TYPE_ID
,      LINE_NUM
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      ITEM_ID
,      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
,      UN_NUMBER_ID
,      HAZARD_CLASS_ID
,      NOTE_TO_VENDOR
,      FROM_HEADER_ID
,      FROM_LINE_ID
,      FROM_LINE_LOCATION_ID
,      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
,      VENDOR_PRODUCT_NUM
,      CONTRACT_NUM
,      TAXABLE_FLAG
,      TAX_NAME
,      TYPE_1099
,      CAPITAL_EXPENSE_FLAG
,      NEGOTIATED_BY_PREPARER_FLAG
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      REFERENCE_NUM
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      MIN_RELEASE_AMOUNT
,      PRICE_TYPE_LOOKUP_CODE
,      CLOSED_CODE
,      PRICE_BREAK_LOOKUP_CODE
,      USSGL_TRANSACTION_CODE
,      GOVERNMENT_CONTEXT
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CLOSED_DATE
,      CLOSED_REASON
,      CLOSED_BY
,      TRANSACTION_REASON_CODE
,      ORG_ID
,      QC_GRADE
,      BASE_UOM
,      BASE_QTY
,      SECONDARY_UOM
,      SECONDARY_QTY
,      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
,      LINE_REFERENCE_NUM
,      PROJECT_ID
,      TASK_ID
,      EXPIRATION_DATE
,      TAX_CODE_ID
,      OKE_CONTRACT_HEADER_ID
,      OKE_CONTRACT_VERSION_ID
,      SECONDARY_QUANTITY
,      SECONDARY_UNIT_OF_MEASURE
,      PREFERRED_GRADE
,      AUCTION_HEADER_ID
,      AUCTION_DISPLAY_NUMBER
,      AUCTION_LINE_NUMBER
,      BID_NUMBER
,      BID_LINE_NUMBER
,      RETROACTIVE_DATE
,      SUPPLIER_REF_NUMBER
,      CONTRACT_ID
,      START_DATE
,      AMOUNT
,      JOB_ID
,      CONTRACTOR_FIRST_NAME
,      CONTRACTOR_LAST_NAME
,      ORDER_TYPE_LOOKUP_CODE
,      PURCHASE_BASIS
,      MATCHING_BASIS
,      SVC_AMOUNT_NOTIF_SENT
,      SVC_COMPLETION_NOTIF_SENT
,      BASE_UNIT_PRICE
,      MANUAL_PRICE_CHANGE_FLAG
,      RETAINAGE_RATE
,      MAX_RETAINAGE_AMOUNT
,      PROGRESS_PAYMENT_RATE
,      RECOUPMENT_RATE
,      CATALOG_NAME
,      SUPPLIER_PART_AUXID
,      IP_CATEGORY_ID
,      TAX_ATTRIBUTE_UPDATE_CODE
,      LAST_UPDATED_PROGRAM
,      GROUP_LINE_ID
,      LINE_NUM_DISPLAY
,      CLM_INFO_FLAG
,      CLM_OPTION_INDICATOR
,      CLM_BASE_LINE_NUM
,      CLM_OPTION_NUM
,      CLM_OPTION_FROM_DATE
,      CLM_OPTION_TO_DATE
,      CLM_FUNDED_FLAG
,      CONTRACT_TYPE
,      COST_CONSTRAINT
,      CLM_IDC_TYPE
,      UDA_TEMPLATE_ID
,      USER_DOCUMENT_STATUS
,      DRAFT_ID
,      LINE_NUM_DISP
,      CLM_MIN_TOTAL_AMOUNT
,      CLM_MAX_TOTAL_AMOUNT
,      CLM_MIN_TOTAL_QUANTITY
,      CLM_MAX_TOTAL_QUANTITY
,      CLM_MIN_ORDER_AMOUNT
,      CLM_MAX_ORDER_AMOUNT
,      CLM_MIN_ORDER_QUANTITY
,      CLM_MAX_ORDER_QUANTITY
,      CLM_TOTAL_AMOUNT_ORDERED
,      CLM_TOTAL_QUANTITY_ORDERED
,      CLM_FSC_PSC
,      CLM_MDAPS_MAIS
,      CLM_NAICS
,      CLM_ORDER_START_DATE
,      CLM_ORDER_END_DATE
FROM APPS.PO_LINES_TRX_V;

Dependencies

[top of page]

APPS.PO_LINES_TRX_V references the following:

APPS: PO_DISTRIBUTIONS_ALL; PO_LINES

APPS.PO_LINES_TRX_V is referenced by following:

APPS: AP_IMPORT_VALIDATION_PKG - show dependent code; INV_LABEL_PVT1 - show dependent code; INV_LABEL_PVT2 - show dependent code; INV_LABEL_PVT3 - show dependent code; INV_LABEL_PVT4 - show dependent code; INV_LABEL_PVT5 - show dependent code; INV_MWB_QUERY_MANAGER - show dependent code; INV_RCV_TXN_INTERFACE - show dependent code; INV_UI_RCV_LOVS - show dependent code; POR_RCV_ALL_ITEMS_V1; POR_RCV_CONF_ITEMS_V; POR_RCV_EXPRESS_ITEMS_V; POR_RCV_HOME_REQS_V; POR_RCV_MY_PURCHASE_ITEMS_V; POR_RCV_PURCHASE_ITEMS_V; POR_RCV_PURCHASE_RECEIPTS_V; POR_RCV_REQS_ALL_V; POR_RCV_REQ_ITEMS_V; POR_RCV_REQ_PURCH_RECEIPTS_V; POR_RCV_RETURN_TO_VENDOR_V; POR_RCV_SHIPMENTS_V; POR_RCV_SHIP_DISP_LINES_V; PO_DISTRIBUTIONS_TRX_V; PO_LINES_VAL_TRX_V; PO_LINE_LOCATIONS_TRX_V; QA_PLAN_ELEMENT_API - show dependent code; RCV_CORRECTIONS_V; RCV_ENTER_RECEIPTS_ASN_V; RCV_ENTER_RECEIPTS_LCM_V; RCV_ENTER_RECEIPTS_PO_V; RCV_MSL_V; RCV_RETURNS_V; RCV_ROI_TRANSACTION - show dependent code; RCV_TRANSACTIONS_V; RCV_VIEW_INTERFACE_V; RCV_VRC_TXS_V; RCV_VRC_TXS_VENDINT_V; WMS_PACKING_WORKBENCH_PVT - show dependent code; WMS_PLAN_TASKS_PVT - show dependent code; WMS_WAVEPLAN_TASKS_PVT - show dependent code