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


VIEW: APPS.WSH_DELIVERY_ASSIGNMENTS_V

Object Details
Object Name: WSH_DELIVERY_ASSIGNMENTS_V
Object Type: VIEW
Owner: APPS
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
Name Datatype Length Mandatory Comments
DELIVERY_ASSIGNMENT_ID NUMBER
Yes
DELIVERY_ID NUMBER

PARENT_DELIVERY_ID NUMBER

DELIVERY_DETAIL_ID NUMBER
Yes
PARENT_DELIVERY_DETAIL_ID NUMBER

CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

PROGRAM_APPLICATION_ID NUMBER

PROGRAM_ID NUMBER

PROGRAM_UPDATE_DATE DATE

REQUEST_ID NUMBER

ACTIVE_FLAG VARCHAR2 (1)
TYPE VARCHAR2 (30)
Query Text

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


SELECT DELIVERY_ASSIGNMENT_ID
,      DELIVERY_ID
,      PARENT_DELIVERY_ID
,      DELIVERY_DETAIL_ID
,      PARENT_DELIVERY_DETAIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      ACTIVE_FLAG
,      TYPE
FROM APPS.WSH_DELIVERY_ASSIGNMENTS_V;

Dependencies

[top of page]

APPS.WSH_DELIVERY_ASSIGNMENTS_V references the following:

SchemaAPPS
SynonymWSH_DELIVERY_ASSIGNMENTS
APPS.WSH_DELIVERY_ASSIGNMENTS_V is referenced by following:

SchemaAPPS
Package BodyCSD_PROCESS_PVT - show dependent code
Package BodyCSD_UPDATE_PROGRAMS_PVT - show dependent code
ViewCSD_WSH_LINE_STATUS_V
Package BodyFTE_PO_INTEGRATION_GRP - show dependent code
Package BodyINV_LABEL_PVT1 - show dependent code
Package BodyINV_LABEL_PVT2 - show dependent code
Package BodyINV_LABEL_PVT3 - show dependent code
Package BodyINV_LABEL_PVT4 - show dependent code
Package BodyINV_LABEL_PVT5 - show dependent code
Package BodyINV_LABEL_PVT7 - show dependent code
Package BodyINV_LABEL_PVT8 - show dependent code
Package BodyINV_MGD_MVT_PO_MDTR - show dependent code
Package BodyINV_MGD_MVT_SO_MDTR - show dependent code
Package BodyINV_PICK_RELEASE_PVT - show dependent code
Package BodyINV_RCV_STD_RCPT_APIS - show dependent code
Package BodyINV_SHIPPING_TRANSACTION_PUB - show dependent code
Package BodyOKE_DSNO_PKG - show dependent code
ViewOKE_DTS_SHIPPING_V
Package BodyOKE_FORM_DD250 - show dependent code
Package BodyRLM_CUM_SV - show dependent code
Package BodyWMS_BULK_PICK - show dependent code
Package BodyWMS_CARTNZN_PUB - show dependent code
Package BodyWMS_CATCH_WEIGHT_PVT - show dependent code
Package BodyWMS_CONSOLIDATION_PUB - show dependent code
Package BodyWMS_CROSS_DOCK_PVT - show dependent code
Package BodyWMS_DEVICE_INTEGRATION_PVT - show dependent code
Package BodyWMS_DIRECT_SHIP_PVT - show dependent code
Package BodyWMS_LPN_LOVS - show dependent code
Package BodyWMS_MDC_PVT - show dependent code
Package BodyWMS_OP_DEST_SYS_APIS - show dependent code
Package BodyWMS_OP_RUNTIME_PUB_APIS - show dependent code
Package BodyWMS_PACKING_WORKBENCH_PVT - show dependent code
Package BodyWMS_PARAMETER_PVT - show dependent code
Package BodyWMS_PICKING_PKG - show dependent code
Package BodyWMS_PICK_DROP_PVT - show dependent code
Package BodyWMS_PUTAWAY_UTILS - show dependent code
Package BodyWMS_REPLENISHMENT_PVT - show dependent code
Package BodyWMS_RFID_DEVICE_PUB - show dependent code
Package BodyWMS_SHIPPING_LOVS - show dependent code
Package BodyWMS_SHIPPING_LPN_UTILS_PUB - show dependent code
Package BodyWMS_SHIPPING_PUB - show dependent code
Package BodyWMS_SHIPPING_TRANSACTION_PUB - show dependent code
Package BodyWMS_TASK_DISPATCH_ENGINE - show dependent code
Package BodyWMS_TASK_DISPATCH_GEN - show dependent code
Package BodyWMS_TASK_DISPATCH_PUT_AWAY - show dependent code
Package BodyWMS_TASK_LOAD - show dependent code
Package BodyWMS_XDOCK_PEGGING_PUB - show dependent code
Package BodyWSH_ASN_RECEIPT_PVT - show dependent code
Package BodyWSH_AUTO_MANIFEST - show dependent code
ViewWSH_BACKORDER_LINES_V
Package BodyWSH_BOLS_UTIL_PKG - show dependent code
Package BodyWSH_BULK_PROCESS_PVT - show dependent code
ViewWSH_CMSTPW_ORDERS_V
Package BodyWSH_CONTAINER_ACTIONS - show dependent code
PL/SQL PackageWSH_CONTAINER_ACTIONS - show dependent code
Package BodyWSH_CONTAINER_GRP - show dependent code
Package BodyWSH_CONTAINER_UTILITIES - show dependent code
Package BodyWSH_DATA_PROTECTION - show dependent code
Package BodyWSH_DCP_PVT - show dependent code
ViewWSH_DELIVERABLE_STOPS_V
ViewWSH_DELIVERABLE_TRIPS_V
Package BodyWSH_DELIVERY_AUTOCREATE - show dependent code
PL/SQL PackageWSH_DELIVERY_DETAILS_ACTIONS - show dependent code
Package BodyWSH_DELIVERY_DETAILS_ACTIONS - show dependent code
Package BodyWSH_DELIVERY_DETAILS_GRP - show dependent code
ViewWSH_DELIVERY_DETAILS_OE_V
Package BodyWSH_DELIVERY_DETAILS_PUB - show dependent code
Package BodyWSH_DELIVERY_DETAILS_UTILITIES - show dependent code
Package BodyWSH_DELIVERY_LEGS_ACTIONS - show dependent code
ViewWSH_DELIVERY_LINE_STATUS_V
Package BodyWSH_DELIVERY_UTIL - show dependent code
Package BodyWSH_DELIVERY_VALIDATIONS - show dependent code
Package BodyWSH_DETAILS_VALIDATIONS - show dependent code
Package BodyWSH_DLVB_COMMON_ACTIONS - show dependent code
ViewWSH_DLVB_DLVY_V
Package BodyWSH_DOCUMENT_PUB - show dependent code
ViewWSH_DSNO_CONTAINERS_V
ViewWSH_DSNO_DELIVERIES_V
ViewWSH_DSNO_DELIVERY_ATTRIBS_V
ViewWSH_DSNO_ITEMS_COMM_V
ViewWSH_DSNO_ITEM_DETAILS_V
Package BodyWSH_DSNO_OKE - show dependent code
ViewWSH_DSNO_ORDERS_COMM_V
ViewWSH_DSNO_ORDERS_SPECIFIC_V
ViewWSH_DSNO_PACKED_QUANTITY_V
ViewWSH_EXCEPTIONS_DLVY_V
Package BodyWSH_EXCEPTIONS_GRP - show dependent code
Package BodyWSH_EXTERNAL_INTERFACE_SV - show dependent code
Package BodyWSH_FC_INTERFACE_PKG - show dependent code
Package BodyWSH_FREIGHT_COSTS_PVT - show dependent code
Package BodyWSH_FTE_COMP_CONSTRAINT_PKG - show dependent code
Package BodyWSH_FTE_CONSTRAINT_FRAMEWORK - show dependent code
Package BodyWSH_IB_TXN_MATCH_PKG - show dependent code
Package BodyWSH_IB_UI_RECON_GRP - show dependent code
Package BodyWSH_INBOUND_SHIP_ADVICE_PKG - show dependent code
Package BodyWSH_INBOUND_UTIL_PKG - show dependent code
Package BodyWSH_INTEGRATION - show dependent code
PL/SQL PackageWSH_INTERFACE - show dependent code
Package BodyWSH_INTERFACE - show dependent code
Package BodyWSH_INTERFACE_COMMON_ACTIONS - show dependent code
Package BodyWSH_INTERFACE_GRP - show dependent code
Package BodyWSH_INTERFACE_VALIDATIONS_PKG - show dependent code
ViewWSH_INV_DELIVERY_DETAILS_V
Package BodyWSH_INV_INTEGRATION_GRP - show dependent code
ViewWSH_ITM_CONTAINERS_V
ViewWSH_ITM_SHIPITEMS_V
Package BodyWSH_LPN_SYNC_COMM_PKG - show dependent code
Package BodyWSH_MAPPING_DATA - show dependent code
Package BodyWSH_NEW_DELIVERIES_PVT - show dependent code
Package BodyWSH_NEW_DELIVERY_ACTIONS - show dependent code
ViewWSH_OE_LINES_V1
Package BodyWSH_PARTY_MERGE - show dependent code
Package BodyWSH_PICK_LIST - show dependent code
Package BodyWSH_PO_CMG_PVT - show dependent code
Package BodyWSH_PO_INTEGRATION_GRP - show dependent code
Package BodyWSH_PR_CRITERIA - show dependent code
Package BodyWSH_PURGE - show dependent code
ViewWSH_PURGE_SET_V
Package BodyWSH_RCV_CORR_RTV_TXN_PKG - show dependent code
Package BodyWSH_RLM_INTERFACE - show dependent code
Package BodyWSH_ROUTING_REQUEST - show dependent code
Package BodyWSH_ROUTING_RESPONSE_PKG - show dependent code
Package BodyWSH_SHIPPING_CONSTRAINTS_PKG - show dependent code
ViewWSH_SHIPPING_DETAILS_V
Package BodyWSH_SHIP_CONFIRM_ACTIONS - show dependent code
Package BodyWSH_SHIP_CONFIRM_ACTIONS2 - show dependent code
ViewWSH_SS_CONTAINERS_V
ViewWSH_SS_SHIPITEMS_V
Package BodyWSH_TPA_SELECTOR_PKG - show dependent code
Package BodyWSH_TP_RELEASE - show dependent code
Package BodyWSH_TP_RELEASE_INT - show dependent code
Package BodyWSH_TRANSACTIONS_TPW_UTIL - show dependent code
Package BodyWSH_TRANSACTIONS_UTIL - show dependent code
Package BodyWSH_TRIP_STOPS_VALIDATIONS - show dependent code
Package BodyWSH_USA_ACTIONS_PVT - show dependent code
PL/SQL PackageWSH_USA_ACTIONS_PVT - show dependent code
Package BodyWSH_USA_CATEGORIES_PVT - show dependent code
Package BodyWSH_USA_INV_PVT - show dependent code
Package BodyWSH_USA_QUANTITY_PVT - show dependent code
Package BodyWSH_UTIL_CORE - show dependent code
Package BodyWSH_WF - show dependent code
Package BodyWSH_WF_INTERFACE - show dependent code
Package BodyWSH_WF_STD - show dependent code
Package BodyWSH_WSHRDBOL_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDBSR_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDINV_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDLAB_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDPAK_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDPIK_XMLP_PKG - show dependent code
Package BodyWSH_WSHRDXCP_XMLP_PKG - show dependent code
Package BodyWSH_WV_UTILS - show dependent code
Package BodyWSH_XC_UTIL - show dependent code