[Home] [Help] [Dependency Information]
Object Name: | ASO_OA_SHIPMENTS_LINE_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SHIPMENT_ID | NUMBER | Yes | Quote shipment identifier | |
CREATION_DATE | DATE | Yes | Standard who column - date when this row was created. | |
CREATED_BY | NUMBER | Yes | Standard who column - user who created this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_DATE | DATE | Yes | Standard Who column - date when a user last updated this row. | |
LAST_UPDATED_BY | NUMBER | Yes | Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID). | |
LAST_UPDATE_LOGIN | NUMBER | Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID). | ||
REQUEST_ID | NUMBER | Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID). | ||
PROGRAM_APPLICATION_ID | NUMBER | Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID). | ||
PROGRAM_ID | NUMBER | Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID). | ||
PROGRAM_UPDATE_DATE | DATE | Concurrent Program who column - date when a program last updated this row). | ||
QUOTE_HEADER_ID | NUMBER | Yes | Quote header identifier | |
QUOTE_LINE_ID | NUMBER | |||
PROMISE_DATE | DATE | In stock promise date - obsolete | ||
REQUEST_DATE | DATE | Need by date | ||
SCHEDULE_SHIP_DATE | DATE | Date planned to ship items - obsolete | ||
SHIP_TO_PARTY_SITE_ID | NUMBER | Ship to site use identifier | ||
SHIP_TO_PARTY_ID | NUMBER | Ship to contact identifier | ||
SHIP_PARTIAL_FLAG | VARCHAR2 | (240) | Indicate all items must ship together or separately | |
SHIP_SET_ID | NUMBER | Ship set identifier if ship_partial_flag is false | ||
SHIP_METHOD_CODE | VARCHAR2 | (30) | Freight Carrier and method. Foreign key to table Org_Freight | |
FREIGHT_TERMS_CODE | VARCHAR2 | (30) | Freight term. Applicable only at header level | |
FREIGHT_CARRIER_CODE | VARCHAR2 | (30) | Used in LOV for selecting the freight carrier and method | |
FOB_CODE | VARCHAR2 | (30) | Point of ownership transfer | |
SHIPPING_INSTRUCTIONS | VARCHAR2 | (2000) | Special shipping instructions | |
PACKING_INSTRUCTIONS | VARCHAR2 | (2000) | Special packing instructions | |
QUANTITY | NUMBER | Quantity for quote shipment line. It is different than aso_quote_lines_all if there are multiple shipments. | ||
RESERVED_QUANTITY | VARCHAR2 | (240) | Quantity reserved - obsolete | |
RESERVATION_ID | NUMBER | Reservation identifier - obsolete | ||
ORDER_LINE_ID | NUMBER | System Generated Line Identifier. | ||
SHIPMENT_PRIORITY_CODE | VARCHAR2 | (30) | SHIPMENT PRIORITY CODE | |
DEMAND_CLASS_CODE | VARCHAR2 | (30) | Demand Class Code | |
REQUEST_DATE_TYPE | VARCHAR2 | (30) | Request date type | |
ATTRIBUTE_CATEGORY | VARCHAR2 | (30) | Descriptive flexfield structure definition column. | |
ATTRIBUTE1 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE2 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE3 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE4 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE5 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE6 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE7 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE8 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE9 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE10 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE11 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE12 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE13 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE14 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE15 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE16 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE17 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE18 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE19 | VARCHAR2 | (240) | Descriptive flexfield segment | |
ATTRIBUTE20 | VARCHAR2 | (240) | Descriptive flexfield segment | |
SHIP_QUOTE_PRICE | NUMBER | unit shipment charges at shipment level | ||
SECURITY_GROUP_ID | NUMBER | Used in hosted environments | ||
OBJECT_VERSION_NUMBER | NUMBER | Used in hosted environments | ||
SHIP_TO_CUST_ACCOUNT_ID | NUMBER | Ship tp customer account identier | ||
SHIP_FROM_ORG_ID | NUMBER | SHIP FROM ORG IDENTIFIER | ||
SHIP_TO_CUST_PARTY_ID | NUMBER | SHIP TO CUST PARTY IDENTIFIER | ||
SHIP_METHOD_CODE_FROM | VARCHAR2 | (30) | Ship Method Code for Term Substitution Modifier | |
FREIGHT_TERMS_CODE_FROM | VARCHAR2 | (30) | Freight Term Code for Term Substitution Modifier | |
SHIPMENT_LINE_DISCRIMINATOR | CHAR | (1) |
Cut, paste (and edit) the following text to query this object:
SELECT SHIPMENT_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, QUOTE_HEADER_ID
, QUOTE_LINE_ID
, PROMISE_DATE
, REQUEST_DATE
, SCHEDULE_SHIP_DATE
, SHIP_TO_PARTY_SITE_ID
, SHIP_TO_PARTY_ID
, SHIP_PARTIAL_FLAG
, SHIP_SET_ID
, SHIP_METHOD_CODE
, FREIGHT_TERMS_CODE
, FREIGHT_CARRIER_CODE
, FOB_CODE
, SHIPPING_INSTRUCTIONS
, PACKING_INSTRUCTIONS
, QUANTITY
, RESERVED_QUANTITY
, RESERVATION_ID
, ORDER_LINE_ID
, SHIPMENT_PRIORITY_CODE
, DEMAND_CLASS_CODE
, REQUEST_DATE_TYPE
, ATTRIBUTE_CATEGORY
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, ATTRIBUTE16
, ATTRIBUTE17
, ATTRIBUTE18
, ATTRIBUTE19
, ATTRIBUTE20
, SHIP_QUOTE_PRICE
, SECURITY_GROUP_ID
, OBJECT_VERSION_NUMBER
, SHIP_TO_CUST_ACCOUNT_ID
, SHIP_FROM_ORG_ID
, SHIP_TO_CUST_PARTY_ID
, SHIP_METHOD_CODE_FROM
, FREIGHT_TERMS_CODE_FROM
, SHIPMENT_LINE_DISCRIMINATOR
FROM APPS.ASO_OA_SHIPMENTS_LINE_V;
APPS.ASO_OA_SHIPMENTS_LINE_V is not referenced by any database object
|
|
|