[Home] [Help] [Dependency Information]
Object Name: | PO_OTM_SCHEDULE_LINE_TYPE |
---|---|
Object Type: | TYPE |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Type Code: | OBJECT |
---|---|
Predefined: | NO |
Incomplete: | NO |
Name | Datatype | Length | Prcn |
---|---|---|---|
PO_LINE_ID | NUMBER |
|
|
LINE_LOCATION_ID | NUMBER |
|
|
LINE_NUM | NUMBER |
|
|
SHIPMENT_NUM | NUMBER |
|
|
QUANTITY | NUMBER |
|
|
QUANTITY_CANCELED | NUMBER |
|
|
PRICE_OVERRIDE | NUMBER |
|
|
ITEM_DESCRIPTION | VARCHAR2 | (240) | |
ITEM | VARCHAR2 | (40) | |
UNIT_VOLUME | NUMBER |
|
|
UNIT_WEIGHT | NUMBER |
|
|
ITEM_REVISION | VARCHAR2 | (3) | |
SUPPLIER_ITEM_ID | VARCHAR2 | (25) | |
SUPPLIER_REF_NUM | VARCHAR2 | (150) | |
UOM | VARCHAR2 | (150) | |
CURRENCY_CODE | VARCHAR2 | (40) | |
ORDER_TYPE_LOOKUP_CODE | VARCHAR2 | (25) | |
NEED_BY_DATE | DATE |
|
|
PROMISED_DATE | DATE |
|
|
DAYS_EARLY_RECEIPT_ALLOWED | NUMBER |
|
|
DAYS_LATE_RECEIPT_ALLOWED | NUMBER |
|
|
DROP_SHIP_FLAG | VARCHAR2 | (1) | |
SHIP_TO_ORGANIZATION_ID | NUMBER |
|
|
SHIP_TO_ORG_NAME | VARCHAR2 | (240) | |
SHIP_TO_LOCATION_ID | NUMBER |
|
|
SHIP_TO_LOCATION_CODE | VARCHAR2 | (60) | |
SHIP_TO_LOC_ADDR_LINE_1 | VARCHAR2 | (240) | |
SHIP_TO_LOC_ADDR_LINE_2 | VARCHAR2 | (240) | |
SHIP_TO_LOC_ADDR_LINE_3 | VARCHAR2 | (240) | |
SHIP_TO_LOC_CITY | VARCHAR2 | (30) | |
SHIP_TO_LOC_COUNTRY | VARCHAR2 | (60) | |
SHIP_TO_LOC_ZIP | VARCHAR2 | (30) | |
SHIP_TO_LOC_STATE_PROVINCE | VARCHAR2 | (120) | |
SHIP_TO_CONTACT_NAME | VARCHAR2 | (400) | |
SHIP_TO_CONTACT_EMAIL | VARCHAR2 | (2000) | |
SHIP_TO_CONTACT_PHONE | VARCHAR2 | (200) | |
SHIP_TO_CONTACT_FAX | VARCHAR2 | (200) | |
RECOVERY_ACTION | VARCHAR2 | (50) |
Name | Parameters | Result |
---|---|---|
NEW_INSTANCE |
|
PO_OTM_SCHEDULE_LINE_TYPE |
|
|
|