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_REC_TYPE

Object Details

Object Name:	PO_LINES_REC_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
UNIT_PRICE	PO_TBL_NUMBER
VENDOR_PRODUCT_NUM	PO_TBL_VARCHAR30
QUANTITY	PO_TBL_NUMBER
START_DATE	PO_TBL_DATE
EXPIRATION_DATE	PO_TBL_DATE
AMOUNT	PO_TBL_NUMBER
REQUEST_UNIT_OF_MEASURE	PO_TBL_VARCHAR30
SECONDARY_QUANTITY	PO_TBL_NUMBER
REQUEST_SECONDARY_UOM	PO_TBL_VARCHAR30
DELETE_RECORD	PO_TBL_VARCHAR1
DELETE_PRICE_ADJS	PO_TBL_VARCHAR1
PREFERRED_GRADE	PO_TBL_VARCHAR240
C_QUANTITY	PO_TBL_NUMBER
C_UNIT_MEAS_LOOKUP_CODE	PO_TBL_VARCHAR30
C_ITEM_ID	PO_TBL_NUMBER
C_FROM_HEADER_ID	PO_TBL_NUMBER
C_FROM_LINE_ID	PO_TBL_NUMBER
C_HAS_GA_REFERENCE	PO_TBL_VARCHAR1
C_CANCEL_FLAG	PO_TBL_VARCHAR1
C_CLOSED_CODE	PO_TBL_VARCHAR30
C_VALUE_BASIS	PO_TBL_VARCHAR30
C_PURCHASE_BASIS	PO_TBL_VARCHAR30
C_AMOUNT	PO_TBL_NUMBER
C_START_DATE	PO_TBL_DATE
C_EXPIRATION_DATE	PO_TBL_DATE
C_UNIT_PRICE	PO_TBL_NUMBER
C_FROM_LINE_LOCATION_ID	PO_TBL_NUMBER
C_SECONDARY_QUANTITY	PO_TBL_NUMBER
C_SECONDARY_UOM	PO_TBL_VARCHAR30
C_ITEM_NUMBER	PO_TBL_VARCHAR40
C_PREFERRED_GRADE	PO_TBL_VARCHAR240
T_FROM_PRICE_BREAK	PO_TBL_VARCHAR1
T_FROM_LINE_LOCATION_ID	PO_TBL_NUMBER
T_BASE_UNIT_PRICE	PO_TBL_NUMBER
T_MANUAL_PRICE_CHANGE_FLAG	PO_TBL_VARCHAR1
T_NEW_SECONDARY_UOM	PO_TBL_VARCHAR30

Methods

Name	Parameters	Result
CREATE_OBJECT	P_PO_LINE_ID(PO_TBL_NUMBER) P_UNIT_PRICE(PO_TBL_NUMBER) P_VENDOR_PRODUCT_NUM(PO_TBL_VARCHAR30) P_QUANTITY(PO_TBL_NUMBER) P_START_DATE(PO_TBL_DATE) P_EXPIRATION_DATE(PO_TBL_DATE) P_AMOUNT(PO_TBL_NUMBER) P_REQUEST_UNIT_OF_MEASURE(PO_TBL_VARCHAR30) P_SECONDARY_QUANTITY(PO_TBL_NUMBER) P_REQUEST_SECONDARY_UOM(PO_TBL_VARCHAR30) P_DELETE_RECORD(PO_TBL_VARCHAR1) P_DELETE_PRICE_ADJS(PO_TBL_VARCHAR1) P_PREFERRED_GRADE(PO_TBL_VARCHAR240)	PO_LINES_REC_TYPE
ADD_CHANGE	SELF(PO_LINES_REC_TYPE) P_PO_LINE_ID(NUMBER) P_UNIT_PRICE(NUMBER) P_VENDOR_PRODUCT_NUM(VARCHAR2) P_QUANTITY(NUMBER) P_START_DATE(DATE) P_EXPIRATION_DATE(DATE) P_AMOUNT(NUMBER) P_REQUEST_UNIT_OF_MEASURE(VARCHAR2) P_SECONDARY_QUANTITY(NUMBER) P_REQUEST_SECONDARY_UOM(VARCHAR2) P_DELETE_RECORD(VARCHAR2) P_DELETE_PRICE_ADJS(VARCHAR2) P_PREFERRED_GRADE(VARCHAR2)
EXTEND_FIELDS	SELF(PO_LINES_REC_TYPE) L_EXTEND_SIZE(NUMBER)
GET_COUNT	SELF(PO_LINES_REC_TYPE)	NUMBER
SET_UNIT_PRICE	SELF(PO_LINES_REC_TYPE) P_INDEX(NUMBER) P_UNIT_PRICE(NUMBER)
SET_QUANTITY	SELF(PO_LINES_REC_TYPE) P_INDEX(NUMBER) P_QUANTITY(NUMBER)
SET_AMOUNT	SELF(PO_LINES_REC_TYPE) P_INDEX(NUMBER) P_AMOUNT(NUMBER)
DUMP_TO_LOG	SELF(PO_LINES_REC_TYPE)

Dependencies

[top of page]

APPS.PO_LINES_REC_TYPE references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR1; PO_TBL_VARCHAR240; PO_TBL_VARCHAR30; PO_TBL_VARCHAR40
SYS: STANDARD - show dependent code

APPS.PO_LINES_REC_TYPE is referenced by following:

APPS: CSP_REPAIR_PO_PVT - show dependent code; MRP_PO_RESCHEDULE - show dependent code; PO_CHANGES_REC_TYPE; PO_CHANGES_REC_TYPE; PO_CHANGE_RESPONSE_PVT - show dependent code; PO_CHG_REQUEST_PVT - show dependent code; PO_DOCUMENT_CHECKS_PVT - show dependent code; PO_DOCUMENT_UPDATE_GRP - show dependent code; PO_DOCUMENT_UPDATE_PVT - show dependent code; PO_LINES_REC_TYPE