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


VIEW: APPS.SO_PICKING_LINE_DET_OEXORRSO_V

Object Details
Object Name: SO_PICKING_LINE_DET_OEXORRSO_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOE.SO_PICKING_LINE_DET_OEXORRSO_V
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
ATTRIBUTE1 VARCHAR2 (150)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
ATTRIBUTE2 VARCHAR2 (150)
ATTRIBUTE3 VARCHAR2 (150)
ATTRIBUTE4 VARCHAR2 (150)
ATTRIBUTE5 VARCHAR2 (150)
ATTRIBUTE6 VARCHAR2 (150)
ATTRIBUTE7 VARCHAR2 (150)
ATTRIBUTE8 VARCHAR2 (150)
ATTRIBUTE9 VARCHAR2 (150)
AUTOSCHEDULED_FLAG VARCHAR2 (1)
CONTEXT VARCHAR2 (30)
CREATED_BY NUMBER
Yes
CREATION_DATE DATE
Yes
CUSTOMER_REQUESTED_LOT_FLAG VARCHAR2 (1)
DELIVERY NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
DEMAND_ID NUMBER

DETAIL_TYPE_CODE VARCHAR2 (30)
INVENTORY_LOCATION_ID NUMBER

INVENTORY_LOCATION_SEGMENTS VARCHAR2 (240)
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER

LATEST_ACCEPTABLE_DATE DATE

LOT_NUMBER VARCHAR2 (30)
PICKING_LINE_DETAIL_ID NUMBER
Yes
PICKING_LINE_ID NUMBER
Yes
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

RELEASED_FLAG VARCHAR2 (1)
REQUESTED_QUANTITY NUMBER
Yes
REQUEST_ID NUMBER (15)
RESERVABLE_FLAG VARCHAR2 (1)
REVISION VARCHAR2 (3)
SCHEDULE_DATE DATE

SCHEDULE_LEVEL NUMBER

SCHEDULE_STATUS_CODE VARCHAR2 (30)
SEGMENT1 VARCHAR2 (40)
SEGMENT10 VARCHAR2 (40)
SEGMENT11 VARCHAR2 (40)
SEGMENT12 VARCHAR2 (40)
SEGMENT13 VARCHAR2 (40)
SEGMENT14 VARCHAR2 (40)
SEGMENT15 VARCHAR2 (40)
SEGMENT16 VARCHAR2 (40)
SEGMENT17 VARCHAR2 (40)
SEGMENT18 VARCHAR2 (40)
SEGMENT19 VARCHAR2 (40)
SEGMENT2 VARCHAR2 (40)
SEGMENT20 VARCHAR2 (40)
SEGMENT3 VARCHAR2 (40)
SEGMENT4 VARCHAR2 (40)
SEGMENT5 VARCHAR2 (40)
SEGMENT6 VARCHAR2 (40)
SEGMENT7 VARCHAR2 (40)
SEGMENT8 VARCHAR2 (40)
SEGMENT9 VARCHAR2 (40)
SERIAL_NUMBER VARCHAR2 (30)
SHIPPED_QUANTITY NUMBER

SUBINVENTORY VARCHAR2 (10)
SUPPLY_SOURCE_HEADER_ID NUMBER

SUPPLY_SOURCE_TYPE NUMBER

TRANSACTABLE_FLAG VARCHAR2 (1)
UPDATE_FLAG VARCHAR2 (1)
WAREHOUSE_ID NUMBER
Yes
WIP_COMPLETED_QUANTITY NUMBER

WIP_RESERVED_QUANTITY NUMBER

ROW_ID ROWID (10)
WAREHOUSE VARCHAR2 (3)
REVISION_CONTROL_FLAG VARCHAR2 (1)
LOT_CONTROL_FLAG VARCHAR2 (1)
INVENTORY_ASSET_FLAG VARCHAR2 (1)
ITEM VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
RESTRICT_SUBINVENTORIES_CODE NUMBER

SCHEDULE_STATUS VARCHAR2 (80)
SO_TRANSACTIONS_FLAG VARCHAR2 (1)
RESERVABLE_TYPE NUMBER

ATP_FLAG VARCHAR2 (1)
DPW_ASSIGNED_FLAG VARCHAR2 (1)
DELIVERY_ID NUMBER

DEPARTURE_ID NUMBER

LOAD_SEQ_NUMBER NUMBER

MASTER_CONTAINER_ITEM_ID NUMBER

DETAIL_CONTAINER_ITEM_ID NUMBER

Query Text

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


SELECT ATTRIBUTE1
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      AUTOSCHEDULED_FLAG
,      CONTEXT
,      CREATED_BY
,      CREATION_DATE
,      CUSTOMER_REQUESTED_LOT_FLAG
,      DELIVERY
,      DEMAND_CLASS_CODE
,      DEMAND_ID
,      DETAIL_TYPE_CODE
,      INVENTORY_LOCATION_ID
,      INVENTORY_LOCATION_SEGMENTS
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      LATEST_ACCEPTABLE_DATE
,      LOT_NUMBER
,      PICKING_LINE_DETAIL_ID
,      PICKING_LINE_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      RELEASED_FLAG
,      REQUESTED_QUANTITY
,      REQUEST_ID
,      RESERVABLE_FLAG
,      REVISION
,      SCHEDULE_DATE
,      SCHEDULE_LEVEL
,      SCHEDULE_STATUS_CODE
,      SEGMENT1
,      SEGMENT10
,      SEGMENT11
,      SEGMENT12
,      SEGMENT13
,      SEGMENT14
,      SEGMENT15
,      SEGMENT16
,      SEGMENT17
,      SEGMENT18
,      SEGMENT19
,      SEGMENT2
,      SEGMENT20
,      SEGMENT3
,      SEGMENT4
,      SEGMENT5
,      SEGMENT6
,      SEGMENT7
,      SEGMENT8
,      SEGMENT9
,      SERIAL_NUMBER
,      SHIPPED_QUANTITY
,      SUBINVENTORY
,      SUPPLY_SOURCE_HEADER_ID
,      SUPPLY_SOURCE_TYPE
,      TRANSACTABLE_FLAG
,      UPDATE_FLAG
,      WAREHOUSE_ID
,      WIP_COMPLETED_QUANTITY
,      WIP_RESERVED_QUANTITY
,      ROW_ID
,      WAREHOUSE
,      REVISION_CONTROL_FLAG
,      LOT_CONTROL_FLAG
,      INVENTORY_ASSET_FLAG
,      ITEM
,      ITEM_DESCRIPTION
,      RESTRICT_SUBINVENTORIES_CODE
,      SCHEDULE_STATUS
,      SO_TRANSACTIONS_FLAG
,      RESERVABLE_TYPE
,      ATP_FLAG
,      DPW_ASSIGNED_FLAG
,      DELIVERY_ID
,      DEPARTURE_ID
,      LOAD_SEQ_NUMBER
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
FROM APPS.SO_PICKING_LINE_DET_OEXORRSO_V;

Dependencies

[top of page]

APPS.SO_PICKING_LINE_DET_OEXORRSO_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageFND_PROFILE - show dependent code
SynonymMTL_PARAMETERS
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
PL/SQL PackageOE_QUERY - show dependent code
SynonymSO_LOOKUPS
SynonymSO_PICKING_LINE_DETAILS

APPS.SO_PICKING_LINE_DET_OEXORRSO_V is not referenced by any database object