DBA Data[Home] [Help] [Dependency Information]

TABLE: JA.JAI_WSH_DEL_DETAILS_GT

Object Details
Object Name: JAI_WSH_DEL_DETAILS_GT
Object Type: TABLE
Owner: JA
FND Design Data: TableJA.JAI_WSH_DEL_DETAILS_GT
Subobject Name:
Status: VALID


This is temporary table to store the shipped quantity


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
DELIVERY_DETAIL_ID NUMBER

Delivery Detail Identifier.
ORGANIZATION_ID NUMBER

Organization Identifier.
INVENTORY_ITEM_ID NUMBER

Identifies the inventory item
SOURCE_HEADER_TYPE_ID NUMBER

Indicates the header type identifier of the sales order.
SHIPPED_QUANTITY NUMBER

The quantity shipped
SOURCE_HEADER_ID NUMBER

Indicates the header identifier of the sales order.
SOURCE_LINE_ID NUMBER

Indicates the line identifier of the sales order.
SPLIT_FROM_DELIVERY_DETAIL_ID NUMBER

Parent line identifier from which it is split.
PROCESSED_FLAG VARCHAR2 (1)
Flag to check whether record is processed. Possible values are Y or N
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT DELIVERY_DETAIL_ID
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      SOURCE_HEADER_TYPE_ID
,      SHIPPED_QUANTITY
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      PROCESSED_FLAG
FROM JA.JAI_WSH_DEL_DETAILS_GT;

Dependencies

[top of page]

JA.JAI_WSH_DEL_DETAILS_GT does not reference any database object

JA.JAI_WSH_DEL_DETAILS_GT is referenced by following:

SchemaJA
ViewJAI_WSH_DEL_DETAILS_GT#