[Home] [Help] [Dependency Information]

VIEW: APPS.WSH_PICKING_RULES_V

Object Details

Object Name:	WSH_PICKING_RULES_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	WSH.WSH_PICKING_RULES_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
,      PICKING_RULE_ID
,      PICKING_RULE_NAME
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      REQUEST_ID
,      BACKORDERS_ONLY_FLAG
,      BACKORDERS
,      EXISTING_RSVS_ONLY_FLAG
,      RESERVATION_STAR
,      SHIPMENT_PRIORITY_CODE
,      SHIPMENT_PRIORITY
,      SHIP_METHOD_CODE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      CUSTOMER_NUMBER
,      ORDER_HEADER_ID
,      ORDER_NUMBER
,      SHIP_SET_NUMBER
,      SHIP_SET_ID
,      INVENTORY_ITEM_ID
,      ORDER_TYPE_ID
,      ORDER_TYPE
,      FROM_REQUESTED_DATE
,      TO_REQUESTED_DATE
,      FROM_SCHEDULED_SHIP_DATE
,      TO_SCHEDULED_SHIP_DATE
,      SHIP_TO_LOCATION_ID
,      SHIP_TO_LOCATION
,      SHIP_FROM_LOCATION
,      SHIP_FROM_LOCATION_ID
,      ORGANIZATION_ID
,      WAREHOUSE_CODE
,      WAREHOUSE
,      PICK_FROM_SUBINVENTORY
,      DEFAULT_STAGE_SUBINVENTORY
,      PICK_FROM_LOCATOR_ID
,      DEFAULT_STAGE_LOCATOR_ID
,      PICK_GROUPING_RULE_ID
,      PICK_GROUPING_RULE_NAME
,      PICK_SEQUENCE_RULE_ID
,      PICK_SEQ_RULE_NAME
,      INCLUDE_PLANNED_LINES
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      AUTOCREATE_DELIVERY_FLAG
,      PROJECT_ID
,      PROJECT_NUMBER
,      TASK_ID
,      TASK_NUMBER
,      AUTODETAIL_PR_FLAG
,      AUTO_PICK_CONFIRM_FLAG
,      DOCUMENT_SET_ID
,      DOC_NAME
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      AUTOPACK_FLAG
,      AUTOPACK_LEVEL
,      SHIP_CONFIRM_RULE_ID
,      TASK_PLANNING_FLAG
,      APPEND_FLAG
,      SCH_START_DAYS
,      SCH_START_HOURS
,      SCH_END_DAYS
,      SCH_END_HOURS
,      REQ_START_DAYS
,      REQ_START_HOURS
,      REQ_END_DAYS
,      REQ_END_HOURS
,      REGION_ID
,      ZONE_ID
,      CATEGORY_ID
,      CATEGORY_SET_ID
,      AC_DELIVERY_CRITERIA
,      REL_SUBINVENTORY
,      TASK_PRIORITY
,      ALLOCATION_METHOD
,      CROSSDOCK_CRITERIA_ID
,      DYNAMIC_REPLENISHMENT_FLAG
FROM APPS.WSH_PICKING_RULES_V;

Dependencies

[top of page]

APPS

FND_PROFILE - show dependent code

HR_ALL_ORGANIZATION_UNITS_TL

HR_GENERAL - show dependent code

HR_ORG_UNITS_NO_JOIN

HR_SECURITY - show dependent code

HZ_CUST_ACCOUNTS

HZ_PARTIES

MTL_PARAMETERS

OE_LOOKUPS

OE_ORDER_HEADERS_ALL

OE_SETS

OE_TRXT_TYPES_NOORGS_VL

PA_CROSS_BUSINESS_GRP - show dependent code

PA_PROJECT_UTILS - show dependent code

PA_SECURITY - show dependent code

PA_TASK_UTILS - show dependent code

PJM_PROJECTS_ALL_V

PJM_TASKS_V

WSH_LOCATIONS

WSH_PICKING_RULES

WSH_PICK_GROUPING_RULES

WSH_PICK_SEQUENCE_RULES

WSH_REPORT_SETS

APPS.WSH_PICKING_RULES_V is not referenced by any database object