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

VIEW: APPS.CSP_MO_LINES_V

Object Details
Object Name: CSP_MO_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSP.CSP_MO_LINES_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
LINE_ID NUMBER
Yes Move order line identifier
REQUEST_NUMBER VARCHAR2 (30) Yes Move order number
MOVE_ORDER_TYPE NUMBER

Move order type
MOVE_ORDER_TYPE_NAME VARCHAR2 (80) Yes Name of move order type
DESCRIPTION VARCHAR2 (240)
Description
HEADER_ID NUMBER
Yes Move order header identifier
TRANSACTION_SOURCE_TYPE_ID NUMBER
Yes Transaction source type identifier
TRANSACTION_TYPE_ID NUMBER
Yes Transaction type identifier
TRANSACTION_TYPE_NAME VARCHAR2 (80) Yes Transaction type name
TRANSACTION_ACTION_ID NUMBER
Yes Transaction action identifier
LINE_NUMBER NUMBER
Yes Move order line number
ORGANIZATION_ID NUMBER
Yes Organization identifier
INVENTORY_ITEM_ID NUMBER
Yes Inventory item identifier
REVISION VARCHAR2 (3)
Item revision
FROM_SUBINVENTORY_ID NUMBER

Source subinventory identifier
FROM_SUBINVENTORY_CODE VARCHAR2 (10)
Source subinventory name
FROM_SUB_LOCATOR_TYPE NUMBER

Source subinventory locator type
FROM_SUB_ASSET NUMBER

Source subinventory asset
FROM_SUB_QUANTITY_TRACKED NUMBER

Quantity tracked source subinventory
FROM_SUB_MATERIAL_ACCOUNT NUMBER

Source subinventory material account
FROM_LOCATOR_ID NUMBER

Source locator identifier
TO_SUBINVENTORY_CODE VARCHAR2 (10)
Destination subinventory name
TO_SUB_LOCATOR_TYPE NUMBER

Destination subinventory locator type
TO_SUB_ASSET NUMBER

Destination subinventory asset
TO_SUB_QUANTITY_TRACKED NUMBER

Quantity tracked destination subinventory
TO_SUB_MATERIAL_ACCOUNT NUMBER

Destination subinventory material account
TO_SUBINVENTORY_ID NUMBER

Destination subinventory identifier
TO_LOCATOR_ID NUMBER

Destination locator identifier
TO_ACCOUNT_ID NUMBER

Destination account identifier
SHIP_TO_LOCATION_ID NUMBER

Ship to location identifier
LOT_NUMBER VARCHAR2 (80)
Lot number
SERIAL_NUMBER_START VARCHAR2 (30)
Beginning serial number
SERIAL_NUMBER_END VARCHAR2 (30)
Ending serial number
UNIT_NUMBER VARCHAR2 (30)
Unit number
UOM_CODE VARCHAR2 (3) Yes Uni of measure
QUANTITY NUMBER
Yes Quantity
QUANTITY_DELIVERED NUMBER

Quantity delivered
QUANTITY_DETAILED NUMBER

Quantity detailed
DATE_REQUIRED DATE
Yes Date required
REASON_ID NUMBER

Reason identifier
REFERENCE VARCHAR2 (240)
Reference
REFERENCE_TYPE_CODE NUMBER

Reference type code
REFERENCE_ID NUMBER

Reference identifier
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
TRANSACTION_HEADER_ID NUMBER

Transaction header identifier
LINE_STATUS NUMBER
Yes Line status
STATUS_DATE DATE
Yes Line status date
LAST_UPDATED_BY NUMBER
Yes Standard Who Column - with the user id from FND_USER
LAST_UPDATE_LOGIN NUMBER

Standard Who Column
LAST_UPDATE_DATE DATE
Yes Standard Who Column
CREATED_BY NUMBER

Standard Who Column - with the user id from FND_USER
CREATION_DATE DATE
Yes Standard Who Column
REQUEST_ID NUMBER

Standard Who Column
PROGRAM_APPLICATION_ID NUMBER

Standard Who Column
PROGRAM_ID NUMBER

Standard Who Column
PROGRAM_UPDATE_DATE DATE

Standard Who Column
ATTRIBUTE1 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE2 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE3 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE4 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE5 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE6 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE7 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE8 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE9 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE10 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE11 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE12 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE13 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE14 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE15 VARCHAR2 (150)
Descriptive Flexfield Segment Column
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive Flexfield Structure Defining column
TXN_SOURCE_ID NUMBER

Transaction source identifier
TXN_SOURCE_LINE_ID NUMBER

Transaction source line identifier
TXN_SOURCE_LINE_DETAIL_ID NUMBER

Transaction source line detail identifier
PRIMARY_QUANTITY NUMBER

Primary quantity
TO_ORGANIZATION_ID NUMBER

Destination organization identifier
PICK_STRATEGY_ID NUMBER

Pick strategy identifier
PUT_AWAY_STRATEGY_ID NUMBER

Put away strategy identifier
FROM_COST_GROUP_ID NUMBER

From cost group identifier
FROM_COST_GROUP_NAME VARCHAR2 (10)
From cost group name
TO_COST_GROUP_ID NUMBER

To cost group identifier
TO_COST_GROUP_NAME VARCHAR2 (10)
To cost group name
LPN_ID NUMBER

LPN identifier
TO_LPN_ID NUMBER

To LPN identifier
REFERENCE_DETAIL_ID NUMBER

Reference detail identifier
ASSIGNMENT_ID NUMBER

Assignment identifier
LPN_NUMBER VARCHAR2 (30)
LPN number
TO_LPN_NUMBER VARCHAR2 (30)
To LPN number
SERVICE_REQUEST_ID NUMBER (35)
Service request identifier
SERVICE_REQUEST_NUMBER VARCHAR2 (64)
Service request number
SERVICE_TASK_ID NUMBER (35)
Service task identifier
SERVICE_TASK_NUMBER VARCHAR2 (30)
Service task number
TASK_ASSIGNMENT_ID NUMBER (35)
Service task assignment identifier
CUSTOMER_PO VARCHAR2 (30)
Customer's purchase order number
SERVICE_COMMENTS VARCHAR2 (240)
Service comments
Query Text

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


SELECT ROW_ID
,      LINE_ID
,      REQUEST_NUMBER
,      MOVE_ORDER_TYPE
,      MOVE_ORDER_TYPE_NAME
,      DESCRIPTION
,      HEADER_ID
,      TRANSACTION_SOURCE_TYPE_ID
,      TRANSACTION_TYPE_ID
,      TRANSACTION_TYPE_NAME
,      TRANSACTION_ACTION_ID
,      LINE_NUMBER
,      ORGANIZATION_ID
,      INVENTORY_ITEM_ID
,      REVISION
,      FROM_SUBINVENTORY_ID
,      FROM_SUBINVENTORY_CODE
,      FROM_SUB_LOCATOR_TYPE
,      FROM_SUB_ASSET
,      FROM_SUB_QUANTITY_TRACKED
,      FROM_SUB_MATERIAL_ACCOUNT
,      FROM_LOCATOR_ID
,      TO_SUBINVENTORY_CODE
,      TO_SUB_LOCATOR_TYPE
,      TO_SUB_ASSET
,      TO_SUB_QUANTITY_TRACKED
,      TO_SUB_MATERIAL_ACCOUNT
,      TO_SUBINVENTORY_ID
,      TO_LOCATOR_ID
,      TO_ACCOUNT_ID
,      SHIP_TO_LOCATION_ID
,      LOT_NUMBER
,      SERIAL_NUMBER_START
,      SERIAL_NUMBER_END
,      UNIT_NUMBER
,      UOM_CODE
,      QUANTITY
,      QUANTITY_DELIVERED
,      QUANTITY_DETAILED
,      DATE_REQUIRED
,      REASON_ID
,      REFERENCE
,      REFERENCE_TYPE_CODE
,      REFERENCE_ID
,      PROJECT_ID
,      TASK_ID
,      TRANSACTION_HEADER_ID
,      LINE_STATUS
,      STATUS_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      ATTRIBUTE_CATEGORY
,      TXN_SOURCE_ID
,      TXN_SOURCE_LINE_ID
,      TXN_SOURCE_LINE_DETAIL_ID
,      PRIMARY_QUANTITY
,      TO_ORGANIZATION_ID
,      PICK_STRATEGY_ID
,      PUT_AWAY_STRATEGY_ID
,      FROM_COST_GROUP_ID
,      FROM_COST_GROUP_NAME
,      TO_COST_GROUP_ID
,      TO_COST_GROUP_NAME
,      LPN_ID
,      TO_LPN_ID
,      REFERENCE_DETAIL_ID
,      ASSIGNMENT_ID
,      LPN_NUMBER
,      TO_LPN_NUMBER
,      SERVICE_REQUEST_ID
,      SERVICE_REQUEST_NUMBER
,      SERVICE_TASK_ID
,      SERVICE_TASK_NUMBER
,      TASK_ASSIGNMENT_ID
,      CUSTOMER_PO
,      SERVICE_COMMENTS
FROM APPS.CSP_MO_LINES_V;

Dependencies

[top of page]

APPS.CSP_MO_LINES_V references the following:

SchemaAPPS
SynonymCSP_MOVEORDER_LINES
SynonymCS_INCIDENTS_ALL
SynonymJTF_TASKS_B
ViewMTL_TXN_REQUEST_LINES_V

APPS.CSP_MO_LINES_V is not referenced by any database object