[Home] [Help] [Dependency Information]

VIEW: APPS.JAI_OM_WSH_DELIVERIES_V

Object Details

Object Name:	JAI_OM_WSH_DELIVERIES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	JA.JAI_OM_WSH_DELIVERIES_V
Subobject Name:
Status:	VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Query Text

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

SELECT ROW_ID
,      SOURCE_HEADER_NUMBER
,      SOURCE_HEADER_TYPE_NAME
,      DELIVERY_DETAIL_ID
,      SOURCE_HEADER_TYPE_ID
,      CUSTOMER_ID
,      SHIP_TO_LOCATION_ID
,      SOURCE_CODE
,      SOURCE_HEADER_ID
,      SOURCE_LINE_ID
,      CUST_PO_NUMBER
,      SOLD_TO_CONTACT_ID
,      INVENTORY_ITEM_ID
,      SHIP_SET_ID
,      ARRIVAL_SET_ID
,      TOP_MODEL_LINE_ID
,      ATO_LINE_ID
,      HOLD_CODE
,      SHIP_MODEL_COMPLETE_FLAG
,      HAZARD_CLASS_ID
,      COUNTRY_OF_ORIGIN
,      CLASSIFICATION
,      SHIP_FROM_LOCATION_ID
,      ORGANIZATION_ID
,      SHIP_TO_CONTACT_ID
,      DELIVER_TO_LOCATION_ID
,      DELIVER_TO_CONTACT_ID
,      INTMED_SHIP_TO_LOCATION_ID
,      INTMED_SHIP_TO_CONTACT_ID
,      SHIP_TOLERANCE_ABOVE
,      SHIP_TOLERANCE_BELOW
,      SRC_REQUESTED_QUANTITY
,      SRC_REQUESTED_QUANTITY_UOM
,      CANCELLED_QUANTITY
,      REQUESTED_QUANTITY
,      REQUESTED_QUANTITY_UOM
,      SHIPPED_QUANTITY
,      DELIVERED_QUANTITY
,      QUALITY_CONTROL_QUANTITY
,      CYCLE_COUNT_QUANTITY
,      MOVE_ORDER_LINE_ID
,      SUBINVENTORY
,      REVISION
,      LOT_NUMBER
,      RELEASED_STATUS
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SERIAL_NUMBER
,      LOCATOR_ID
,      DATE_REQUESTED
,      DATE_SCHEDULED
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
,      LOAD_SEQ_NUMBER
,      SHIP_METHOD_CODE
,      CARRIER_ID
,      FREIGHT_TERMS_CODE
,      SHIPMENT_PRIORITY_CODE
,      FOB_CODE
,      CUSTOMER_ITEM_ID
,      DEP_PLAN_REQUIRED_FLAG
,      CUSTOMER_PROD_SEQ
,      CUSTOMER_DOCK_CODE
,      NET_WEIGHT
,      WEIGHT_UOM_CODE
,      VOLUME
,      VOLUME_UOM_CODE
,      SHIPPING_INSTRUCTIONS
,      PACKING_INSTRUCTIONS
,      PROJECT_ID
,      TASK_ID
,      ORG_ID
,      OE_INTERFACED_FLAG
,      MVT_STAT_STATUS
,      TRACKING_NUMBER
,      TRANSACTION_TEMP_ID
,      TP_ATTRIBUTE_CATEGORY
,      TP_ATTRIBUTE1
,      TP_ATTRIBUTE2
,      TP_ATTRIBUTE3
,      TP_ATTRIBUTE4
,      TP_ATTRIBUTE5
,      TP_ATTRIBUTE6
,      TP_ATTRIBUTE7
,      TP_ATTRIBUTE8
,      TP_ATTRIBUTE9
,      TP_ATTRIBUTE10
,      TP_ATTRIBUTE11
,      TP_ATTRIBUTE12
,      TP_ATTRIBUTE13
,      TP_ATTRIBUTE14
,      TP_ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      MOVEMENT_ID
,      SPLIT_FROM_DELIVERY_DETAIL_ID
,      INV_INTERFACED_FLAG
,      SOURCE_LINE_NUMBER
,      SEAL_CODE
,      MINIMUM_FILL_PERCENT
,      MAXIMUM_VOLUME
,      MAXIMUM_LOAD_WEIGHT
,      MASTER_SERIAL_NUMBER
,      GROSS_WEIGHT
,      FILL_PERCENT
,      CONTAINER_NAME
,      CONTAINER_TYPE_CODE
,      CONTAINER_FLAG
,      PREFERRED_GRADE
,      SRC_REQUESTED_QUANTITY2
,      SRC_REQUESTED_QUANTITY_UOM2
,      REQUESTED_QUANTITY2
,      SHIPPED_QUANTITY2
,      DELIVERED_QUANTITY2
,      CANCELLED_QUANTITY2
,      QUALITY_CONTROL_QUANTITY2
,      CYCLE_COUNT_QUANTITY2
,      REQUESTED_QUANTITY_UOM2
,      SUBLOT_NUMBER
,      UNIT_PRICE
,      CURRENCY_CODE
,      UNIT_NUMBER
,      FREIGHT_CLASS_CAT_ID
,      COMMODITY_CODE_CAT_ID
,      ITEM_DESCRIPTION
,      LAST_UPDATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      DELIVERY_ID
,      DELIVERY_NAME
,      STATUS_CODE
,      WAYBILL
,      CONFIRM_DATE
,      DELIVERY_TYPE
,      FREIGHT_CURRENCY
,      DELIVERY_ASSIGNMENT_ID
,      PARENT_DELIVERY_ID
,      PARENT_DELIVERY_DETAIL_ID
FROM APPS.JAI_OM_WSH_DELIVERIES_V;

Dependencies

[top of page]

APPS

WSH_DELIVERY_ASSIGNMENTS

WSH_DELIVERY_DETAILS

WSH_NEW_DELIVERIES

APPS.JAI_OM_WSH_DELIVERIES_V is not referenced by any database object