[Home] [Help] [Dependency Information]
Object Name: | PO_LINES_REC_TYPE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
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 |
|
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) |
|
|
|
|