[Home] [Help] [Dependency Information]
Object Name: | PO_SHIPMENTS_REC_TYPE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
PO_LINE_LOCATION_ID | PO_TBL_NUMBER |
|
|
QUANTITY | PO_TBL_NUMBER |
|
|
PROMISED_DATE | PO_TBL_DATE |
|
|
PRICE_OVERRIDE | PO_TBL_NUMBER |
|
|
PARENT_LINE_LOCATION_ID | PO_TBL_NUMBER |
|
|
SPLIT_SHIPMENT_NUM | PO_TBL_NUMBER |
|
|
NEED_BY_DATE | PO_TBL_DATE |
|
|
SHIP_TO_LOCATION_ID | PO_TBL_NUMBER |
|
|
SALES_ORDER_UPDATE_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 |
|
|
PREFERRED_GRADE | PO_TBL_VARCHAR240 |
|
|
PAYMENT_TYPE | PO_TBL_VARCHAR30 |
|
|
DESCRIPTION | PO_TBL_VARCHAR240 |
|
|
NEW_SUPP_ORDER_LINE_NO | PO_TBL_VARCHAR25 |
|
|
C_PO_LINE_ID | PO_TBL_NUMBER |
|
|
C_QUANTITY | PO_TBL_NUMBER |
|
|
C_UNIT_MEAS_LOOKUP_CODE | PO_TBL_VARCHAR30 |
|
|
C_CANCEL_FLAG | PO_TBL_VARCHAR1 |
|
|
C_CLOSED_CODE | PO_TBL_VARCHAR30 |
|
|
C_ITEM_ID | PO_TBL_NUMBER |
|
|
C_SHIP_TO_ORGANIZATION_ID | PO_TBL_NUMBER |
|
|
C_DROP_SHIP_FLAG | PO_TBL_VARCHAR1 |
|
|
C_QUANTITY_RECEIVED | PO_TBL_NUMBER |
|
|
C_QUANTITY_BILLED | PO_TBL_NUMBER |
|
|
C_AMOUNT_RECEIVED | PO_TBL_NUMBER |
|
|
C_AMOUNT_BILLED | PO_TBL_NUMBER |
|
|
C_ACCRUE_ON_RECEIPT_FLAG | PO_TBL_VARCHAR1 |
|
|
C_VALUE_BASIS | PO_TBL_VARCHAR30 |
|
|
C_PURCHASE_BASIS | PO_TBL_VARCHAR30 |
|
|
C_AMOUNT | PO_TBL_NUMBER |
|
|
C_PRICE_OVERRIDE | PO_TBL_NUMBER |
|
|
C_PARENT_QUANTITY | PO_TBL_NUMBER |
|
|
C_PARENT_AMOUNT | PO_TBL_NUMBER |
|
|
C_SECONDARY_QUANTITY | PO_TBL_NUMBER |
|
|
C_SECONDARY_UOM | PO_TBL_VARCHAR30 |
|
|
C_ITEM_NUMBER | PO_TBL_VARCHAR40 |
|
|
C_APPROVED_DATE | PO_TBL_DATE |
|
|
C_ENCUMBERED_FLAG | PO_TBL_VARCHAR1 |
|
|
C_SHIPMENT_TYPE | PO_TBL_VARCHAR30 |
|
|
C_QUANTITY_SHIPPED | PO_TBL_NUMBER |
|
|
C_PREFERRED_GRADE | PO_TBL_VARCHAR240 |
|
|
C_PAYMENT_TYPE | PO_TBL_VARCHAR30 |
|
|
T_FROM_PRICE_BREAK | PO_TBL_VARCHAR1 |
|
|
T_MANUAL_PRICE_CHANGE_FLAG | PO_TBL_VARCHAR1 |
|
|
T_SEC_QTY_GRADE_CHANGE_ONLY | PO_TBL_VARCHAR1 |
|
Name | Parameters | Result |
---|---|---|
CREATE_OBJECT |
P_PO_LINE_LOCATION_ID(PO_TBL_NUMBER) P_QUANTITY(PO_TBL_NUMBER) P_PROMISED_DATE(PO_TBL_DATE) P_PRICE_OVERRIDE(PO_TBL_NUMBER) P_PARENT_LINE_LOCATION_ID(PO_TBL_NUMBER) P_SPLIT_SHIPMENT_NUM(PO_TBL_NUMBER) P_NEED_BY_DATE(PO_TBL_DATE) P_SHIP_TO_LOCATION_ID(PO_TBL_NUMBER) P_SALES_ORDER_UPDATE_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_PAYMENT_TYPE(PO_TBL_VARCHAR30) P_DESCRIPTION(PO_TBL_VARCHAR240) P_NEW_SUPP_ORDER_LINE_NO(PO_TBL_VARCHAR25) |
PO_SHIPMENTS_REC_TYPE |
ADD_CHANGE |
SELF(PO_SHIPMENTS_REC_TYPE) P_PO_LINE_LOCATION_ID(NUMBER) P_QUANTITY(NUMBER) P_PROMISED_DATE(DATE) P_PRICE_OVERRIDE(NUMBER) P_PARENT_LINE_LOCATION_ID(NUMBER) P_SPLIT_SHIPMENT_NUM(NUMBER) P_NEED_BY_DATE(DATE) P_SHIP_TO_LOCATION_ID(NUMBER) P_SALES_ORDER_UPDATE_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) P_PAYMENT_TYPE(VARCHAR2) P_DESCRIPTION(VARCHAR2) P_NEW_SUPP_ORDER_LINE_NO(VARCHAR2) |
|
EXTEND_FIELDS |
SELF(PO_SHIPMENTS_REC_TYPE) L_EXTEND_SIZE(NUMBER) |
|
GET_COUNT |
SELF(PO_SHIPMENTS_REC_TYPE) |
NUMBER |
SET_QUANTITY |
SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_QUANTITY(NUMBER) |
|
SET_PRICE_OVERRIDE |
SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_PRICE_OVERRIDE(NUMBER) |
|
SET_AMOUNT |
SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_AMOUNT(NUMBER) |
|
SET_GRADE_FLAG |
SELF(PO_SHIPMENTS_REC_TYPE) P_INDEX(NUMBER) P_FLAG(VARCHAR2) |
|
DUMP_TO_LOG |
SELF(PO_SHIPMENTS_REC_TYPE) |
|
|
|
|