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: PO.PO_LINES_ALL#

Object Details

Object Name:	PO_LINES_ALL#
Object Type:	VIEW
Owner:	PO
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
PO_LINE_ID	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER		Yes
PO_HEADER_ID	NUMBER		Yes
LINE_TYPE_ID	NUMBER
LINE_NUM	NUMBER		Yes
LAST_UPDATE_LOGIN	NUMBER
CREATION_DATE	DATE
CREATED_BY	NUMBER
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
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)
ATTRIBUTE2	VARCHAR2	(150)
ATTRIBUTE3	VARCHAR2	(150)
ATTRIBUTE4	VARCHAR2	(150)
ATTRIBUTE5	VARCHAR2	(150)
ATTRIBUTE6	VARCHAR2	(150)
ATTRIBUTE7	VARCHAR2	(150)
ATTRIBUTE8	VARCHAR2	(150)
ATTRIBUTE9	VARCHAR2	(150)
ATTRIBUTE10	VARCHAR2	(150)
REFERENCE_NUM	VARCHAR2	(25)
ATTRIBUTE11	VARCHAR2	(150)
ATTRIBUTE12	VARCHAR2	(150)
ATTRIBUTE13	VARCHAR2	(150)
ATTRIBUTE14	VARCHAR2	(150)
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
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
CLOSED_DATE	DATE
CLOSED_REASON	VARCHAR2	(240)
CLOSED_BY	NUMBER	(9)
TRANSACTION_REASON_CODE	VARCHAR2	(25)
ORG_ID	NUMBER
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
FROM_LINE_LOCATION_ID	NUMBER
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
CLM_EXERCISED_FLAG	VARCHAR2	(1)
CLM_EXERCISED_DATE	DATE
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
REVISION_NUM	NUMBER
CLM_APPROVED_UNDEF_AMOUNT	NUMBER
CLM_DELIVERY_EVENT_CODE	VARCHAR2	(30)
CLM_EXHIBIT_NAME	VARCHAR2	(10)
CLM_PAYMENT_INSTR_CODE	VARCHAR2	(30)
CLM_POP_EXCEPTION_REASON	VARCHAR2	(4000)
CLM_UDA_PRICING_TOTAL	NUMBER
CLM_UNDEF_ACTION_CODE	VARCHAR2	(10)
CLM_UNDEF_FLAG	VARCHAR2	(1)

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
,      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
,      FROM_LINE_LOCATION_ID
,      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
,      CLM_EXERCISED_FLAG
,      CLM_EXERCISED_DATE
,      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
,      REVISION_NUM
,      CLM_APPROVED_UNDEF_AMOUNT
,      CLM_DELIVERY_EVENT_CODE
,      CLM_EXHIBIT_NAME
,      CLM_PAYMENT_INSTR_CODE
,      CLM_POP_EXCEPTION_REASON
,      CLM_UDA_PRICING_TOTAL
,      CLM_UNDEF_ACTION_CODE
,      CLM_UNDEF_FLAG
FROM PO.PO_LINES_ALL#;

Dependencies

[top of page]

PO.PO_LINES_ALL# references the following:

PO: PO_LINES_ALL

PO.PO_LINES_ALL# is referenced by following:

APPS: ITG_IP_LINES_ALL_ARU; JAI_PO_LA_ARIUD_T1; PO_LINES; PO_LINES_ALL