[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 |
![]() |
|
|
UNIT_PRICE |
![]() |
|
|
VENDOR_PRODUCT_NUM |
![]() |
|
|
QUANTITY |
![]() |
|
|
START_DATE |
![]() |
|
|
EXPIRATION_DATE |
![]() |
|
|
AMOUNT |
![]() |
|
|
REQUEST_UNIT_OF_MEASURE |
![]() |
|
|
SECONDARY_QUANTITY |
![]() |
|
|
REQUEST_SECONDARY_UOM |
![]() |
|
|
DELETE_RECORD |
![]() |
|
|
PREFERRED_GRADE |
![]() |
|
|
C_QUANTITY |
![]() |
|
|
C_UNIT_MEAS_LOOKUP_CODE |
![]() |
|
|
C_ITEM_ID |
![]() |
|
|
C_FROM_HEADER_ID |
![]() |
|
|
C_FROM_LINE_ID |
![]() |
|
|
C_HAS_GA_REFERENCE |
![]() |
|
|
C_CANCEL_FLAG |
![]() |
|
|
C_CLOSED_CODE |
![]() |
|
|
C_VALUE_BASIS |
![]() |
|
|
C_PURCHASE_BASIS |
![]() |
|
|
C_AMOUNT |
![]() |
|
|
C_START_DATE |
![]() |
|
|
C_EXPIRATION_DATE |
![]() |
|
|
C_UNIT_PRICE |
![]() |
|
|
C_FROM_LINE_LOCATION_ID |
![]() |
|
|
C_SECONDARY_QUANTITY |
![]() |
|
|
C_SECONDARY_UOM |
![]() |
|
|
C_ITEM_NUMBER |
![]() |
|
|
C_PREFERRED_GRADE |
![]() |
|
|
T_FROM_PRICE_BREAK |
![]() |
|
|
T_FROM_LINE_LOCATION_ID |
![]() |
|
|
T_BASE_UNIT_PRICE |
![]() |
|
|
T_MANUAL_PRICE_CHANGE_FLAG |
![]() |
|
|
T_NEW_SECONDARY_UOM |
![]() |
|
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_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_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) |
|
|
|
|