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]

TYPE: APPS.PO_LINES_VAL_TYPE

Object Details

Object Name:	PO_LINES_VAL_TYPE
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
PO_LINE_ID	PO_TBL_NUMBER
LAST_UPDATE_DATE	PO_TBL_DATE
LAST_UPDATED_BY	PO_TBL_NUMBER
PO_HEADER_ID	PO_TBL_NUMBER
LINE_TYPE_ID	PO_TBL_NUMBER
LINE_NUM	PO_TBL_NUMBER
LAST_UPDATE_LOGIN	PO_TBL_NUMBER
CREATION_DATE	PO_TBL_DATE
CREATED_BY	PO_TBL_NUMBER
ITEM_ID	PO_TBL_NUMBER
ITEM_REVISION	PO_TBL_VARCHAR5
CATEGORY_ID	PO_TBL_NUMBER
ITEM_DESCRIPTION	PO_TBL_VARCHAR2000
UNIT_MEAS_LOOKUP_CODE	PO_TBL_VARCHAR30
QUANTITY_COMMITTED	PO_TBL_NUMBER
COMMITTED_AMOUNT	PO_TBL_NUMBER
ALLOW_PRICE_OVERRIDE_FLAG	PO_TBL_VARCHAR1
NOT_TO_EXCEED_PRICE	PO_TBL_NUMBER
LIST_PRICE_PER_UNIT	PO_TBL_NUMBER
UNIT_PRICE	PO_TBL_NUMBER
QUANTITY	PO_TBL_NUMBER
UN_NUMBER_ID	PO_TBL_NUMBER
HAZARD_CLASS_ID	PO_TBL_NUMBER
NOTE_TO_VENDOR	PO_TBL_VARCHAR2000
FROM_HEADER_ID	PO_TBL_NUMBER
FROM_LINE_ID	PO_TBL_NUMBER
FROM_LINE_LOCATION_ID	PO_TBL_NUMBER
MIN_ORDER_QUANTITY	PO_TBL_NUMBER
MAX_ORDER_QUANTITY	PO_TBL_NUMBER
QTY_RCV_TOLERANCE	PO_TBL_NUMBER
OVER_TOLERANCE_ERROR_FLAG	PO_TBL_VARCHAR30
MARKET_PRICE	PO_TBL_NUMBER
UNORDERED_FLAG	PO_TBL_VARCHAR1
CLOSED_FLAG	PO_TBL_VARCHAR1
USER_HOLD_FLAG	PO_TBL_VARCHAR1
CANCEL_FLAG	PO_TBL_VARCHAR1
CANCELLED_BY	PO_TBL_NUMBER
CANCEL_DATE	PO_TBL_DATE
CANCEL_REASON	PO_TBL_VARCHAR2000
FIRM_STATUS_LOOKUP_CODE	PO_TBL_VARCHAR30
FIRM_DATE	PO_TBL_DATE
VENDOR_PRODUCT_NUM	PO_TBL_VARCHAR30
CONTRACT_NUM	PO_TBL_VARCHAR30
TAXABLE_FLAG	PO_TBL_VARCHAR1
TAX_NAME	PO_TBL_VARCHAR30
TYPE_1099	PO_TBL_VARCHAR30
CAPITAL_EXPENSE_FLAG	PO_TBL_VARCHAR1
NEGOTIATED_BY_PREPARER_FLAG	PO_TBL_VARCHAR1
ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR30
ATTRIBUTE1	PO_TBL_VARCHAR2000
ATTRIBUTE2	PO_TBL_VARCHAR2000
ATTRIBUTE3	PO_TBL_VARCHAR2000
ATTRIBUTE4	PO_TBL_VARCHAR2000
ATTRIBUTE5	PO_TBL_VARCHAR2000
ATTRIBUTE6	PO_TBL_VARCHAR2000
ATTRIBUTE7	PO_TBL_VARCHAR2000
ATTRIBUTE8	PO_TBL_VARCHAR2000
ATTRIBUTE9	PO_TBL_VARCHAR2000
ATTRIBUTE10	PO_TBL_VARCHAR2000
REFERENCE_NUM	PO_TBL_VARCHAR30
ATTRIBUTE11	PO_TBL_VARCHAR2000
ATTRIBUTE12	PO_TBL_VARCHAR2000
ATTRIBUTE13	PO_TBL_VARCHAR2000
ATTRIBUTE14	PO_TBL_VARCHAR2000
ATTRIBUTE15	PO_TBL_VARCHAR2000
MIN_RELEASE_AMOUNT	PO_TBL_NUMBER
PRICE_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
CLOSED_CODE	PO_TBL_VARCHAR30
PRICE_BREAK_LOOKUP_CODE	PO_TBL_VARCHAR30
USSGL_TRANSACTION_CODE	PO_TBL_VARCHAR30
GOVERNMENT_CONTEXT	PO_TBL_VARCHAR30
REQUEST_ID	PO_TBL_NUMBER
PROGRAM_APPLICATION_ID	PO_TBL_NUMBER
PROGRAM_ID	PO_TBL_NUMBER
PROGRAM_UPDATE_DATE	PO_TBL_DATE
CLOSED_DATE	PO_TBL_DATE
CLOSED_REASON	PO_TBL_VARCHAR2000
CLOSED_BY	PO_TBL_NUMBER
TRANSACTION_REASON_CODE	PO_TBL_VARCHAR30
ORG_ID	PO_TBL_NUMBER
QC_GRADE	PO_TBL_VARCHAR30
BASE_UOM	PO_TBL_VARCHAR30
BASE_QTY	PO_TBL_NUMBER
SECONDARY_UOM	PO_TBL_VARCHAR30
SECONDARY_QTY	PO_TBL_NUMBER
GLOBAL_ATTRIBUTE_CATEGORY	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE1	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE2	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE3	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE4	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE5	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE6	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE7	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE8	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE9	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE10	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE11	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE12	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE13	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE14	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE15	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE16	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE17	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE18	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE19	PO_TBL_VARCHAR2000
GLOBAL_ATTRIBUTE20	PO_TBL_VARCHAR2000
LINE_REFERENCE_NUM	PO_TBL_VARCHAR30
PROJECT_ID	PO_TBL_NUMBER
TASK_ID	PO_TBL_NUMBER
EXPIRATION_DATE	PO_TBL_DATE
TAX_CODE_ID	PO_TBL_NUMBER
OKE_CONTRACT_HEADER_ID	PO_TBL_NUMBER
OKE_CONTRACT_VERSION_ID	PO_TBL_NUMBER
SECONDARY_QUANTITY	PO_TBL_NUMBER
SECONDARY_UNIT_OF_MEASURE	PO_TBL_VARCHAR30
PREFERRED_GRADE	PO_TBL_VARCHAR2000
AUCTION_HEADER_ID	PO_TBL_NUMBER
AUCTION_DISPLAY_NUMBER	PO_TBL_VARCHAR100
AUCTION_LINE_NUMBER	PO_TBL_NUMBER
BID_NUMBER	PO_TBL_NUMBER
BID_LINE_NUMBER	PO_TBL_NUMBER
RETROACTIVE_DATE	PO_TBL_DATE
SUPPLIER_REF_NUMBER	PO_TBL_VARCHAR2000
CONTRACT_ID	PO_TBL_NUMBER
START_DATE	PO_TBL_DATE
AMOUNT	PO_TBL_NUMBER
JOB_ID	PO_TBL_NUMBER
CONTRACTOR_FIRST_NAME	PO_TBL_VARCHAR2000
CONTRACTOR_LAST_NAME	PO_TBL_VARCHAR2000
ORDER_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
PURCHASE_BASIS	PO_TBL_VARCHAR30
MATCHING_BASIS	PO_TBL_VARCHAR30
SVC_AMOUNT_NOTIF_SENT	PO_TBL_VARCHAR1
SVC_COMPLETION_NOTIF_SENT	PO_TBL_VARCHAR1
BASE_UNIT_PRICE	PO_TBL_NUMBER
MANUAL_PRICE_CHANGE_FLAG	PO_TBL_VARCHAR1
DRAFT_ID	PO_TBL_NUMBER
CHANGE_ACCEPTED_FLAG	PO_TBL_VARCHAR1
DELETE_FLAG	PO_TBL_VARCHAR1
RETAINAGE_RATE	PO_TBL_NUMBER
MAX_RETAINAGE_AMOUNT	PO_TBL_NUMBER
PROGRESS_PAYMENT_RATE	PO_TBL_NUMBER
RECOUPMENT_RATE	PO_TBL_NUMBER
CATALOG_NAME	PO_TBL_VARCHAR2000
SUPPLIER_PART_AUXID	PO_TBL_VARCHAR2000
IP_CATEGORY_ID	PO_TBL_NUMBER
INVENTORY_ORG_ID	PO_TBL_NUMBER
JOB_BUSINESS_GROUP_ID	PO_TBL_NUMBER
GLOBAL_AGREEMENT_FLAG	PO_TBL_VARCHAR1
INTERFACE_ID	PO_TBL_NUMBER
RELEASE_NUM	PO_TBL_NUMBER
PO_RELEASE_ID	PO_TBL_NUMBER
SOURCE_SHIPMENT_ID	PO_TBL_NUMBER
FIRM_FLAG	PO_TBL_VARCHAR1
FREIGHT_CARRIER	PO_TBL_VARCHAR30
FOB_LOOKUP_CODE	PO_TBL_VARCHAR30
FREIGHT_TERMS_LOOKUP_CODE	PO_TBL_VARCHAR30
SHIPMENT_NUM	PO_TBL_NUMBER
NEED_BY_DATE	PO_TBL_DATE
PROMISED_DATE	PO_TBL_DATE
RECEIPT_REQUIRED_FLAG	PO_TBL_VARCHAR1
INVOICE_CLOSE_TOLERANCE	PO_TBL_NUMBER
RECEIVE_CLOSE_TOLERANCE	PO_TBL_NUMBER
DAYS_EARLY_RECEIPT_ALLOWED	PO_TBL_NUMBER
DAYS_LATE_RECEIPT_ALLOWED	PO_TBL_NUMBER
ENFORCE_SHIP_TO_LOCATION_CODE	PO_TBL_VARCHAR30
ALLOW_SUBSTITUTE_RECEIPTS_FLAG	PO_TBL_VARCHAR1
RECEIVING_ROUTING	PO_TBL_VARCHAR30
RECEIVING_ROUTING_ID	PO_TBL_NUMBER
QTY_RCV_EXCEPTION_CODE	PO_TBL_VARCHAR30
RECEIPT_DAYS_EXCEPTION_CODE	PO_TBL_VARCHAR30
INSPECTION_REQUIRED_FLAG	PO_TBL_VARCHAR1
ITEM	PO_TBL_VARCHAR2000
HDR_END_DATE	PO_TBL_DATE
HDR_START_DATE	PO_TBL_DATE
HDR_TYPE_LOOKUP_CODE	PO_TBL_VARCHAR30
HDR_VENDOR_ID	PO_TBL_NUMBER
HDR_VENDOR_SITE_ID	PO_TBL_NUMBER
HDR_STYLE_ID	PO_TBL_NUMBER
HDR_CURRENCY_CODE	PO_TBL_VARCHAR30
HDR_RATE_TYPE	PO_TBL_VARCHAR30
ADVANCE_AMOUNT	PO_TBL_NUMBER
CLM_INFO_FLAG	PO_TBL_VARCHAR1
CLM_OPTION_INDICATOR	PO_TBL_VARCHAR1
CLM_FUNDED_FLAG	PO_TBL_VARCHAR1
GROUP_LINE_ID	PO_TBL_NUMBER
CLM_BASE_LINE_NUM	PO_TBL_NUMBER
CLM_OPTION_NUM	PO_TBL_NUMBER
CLM_OPTION_FROM_DATE	PO_TBL_DATE
CLM_OPTION_TO_DATE	PO_TBL_DATE
CLM_EXERCISED_FLAG	PO_TBL_VARCHAR1
CLM_EXERCISED_DATE	PO_TBL_DATE
LINE_NUM_DISPLAY	PO_TBL_VARCHAR100
COST_CONSTRAINT	PO_TBL_VARCHAR30
USER_DOCUMENT_STATUS	PO_TBL_VARCHAR30
CONTROL_ACTION	PO_TBL_VARCHAR30
CLM_ORDER_START_DATE	PO_TBL_DATE
CLM_ORDER_END_DATE	PO_TBL_DATE
CLM_MAX_TOTAL_AMOUNT	PO_TBL_NUMBER
CLM_MIN_TOTAL_AMOUNT	PO_TBL_NUMBER
CLM_MAX_TOTAL_QUANTITY	PO_TBL_NUMBER
CLM_MIN_TOTAL_QUANTITY	PO_TBL_NUMBER
CLM_MAX_ORDER_AMOUNT	PO_TBL_NUMBER
CLM_MIN_ORDER_AMOUNT	PO_TBL_NUMBER
CLM_MAX_ORDER_QUANTITY	PO_TBL_NUMBER
CLM_MIN_ORDER_QUANTITY	PO_TBL_NUMBER
CONTRACT_TYPE	PO_TBL_VARCHAR240
OKE_CONTRACT_HEADER_NUM	PO_TBL_VARCHAR240
CLM_IDC_TYPE	PO_TBL_VARCHAR240
INTERFACE_HEADER_ID	PO_TBL_NUMBER
CLM_EXHIBIT_NAME	PO_TBL_VARCHAR20
OLD_QUANTITY	PO_TBL_NUMBER
OLD_UNIT_PRICE	PO_TBL_NUMBER
COMMENTS	PO_TBL_VARCHAR2000
DRAFT_TYPE	PO_TBL_VARCHAR30
PAR_DRAFT_ID	PO_TBL_VARCHAR4000
AMOUNT_CHANGED_FLAG	PO_TBL_VARCHAR1

Methods

Name	Parameters	Result
PO_LINES_VAL_TYPE	SELF(PO_LINES_VAL_TYPE)	PO_LINES_VAL_TYPE

Dependencies

[top of page]

APPS.PO_LINES_VAL_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR100; PO_TBL_VARCHAR20; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR240; PO_TBL_VARCHAR30; PO_TBL_VARCHAR4000; PO_TBL_VARCHAR5

APPS.PO_LINES_VAL_TYPE is referenced by following:

APPS: PO_LINES_VAL_TYPE; PO_MOD_SYNC_PROCESS_PVT - show dependent code; PO_PDOI_LINE_PROCESS_PVT - show dependent code; PO_VALIDATIONS - show dependent code; PO_VALIDATIONS - show dependent code