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


VIEW: APPS.SO_LINE_DETAILS_V

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

[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
LINE_DETAIL_ID NUMBER
Yes
CREATION_DATE DATE
Yes
CREATED_BY NUMBER
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER
Yes
LAST_UPDATE_LOGIN NUMBER

LINE_ID NUMBER
Yes
INVENTORY_ITEM_ID NUMBER
Yes
INCLUDED_ITEM_FLAG VARCHAR2 (1) Yes
COMPONENT_SEQUENCE_ID NUMBER

COMPONENT_CODE VARCHAR2 (1000) Yes
COMPONENT_RATIO NUMBER
Yes
SHIPPABLE_FLAG VARCHAR2 (1)
TRANSACTABLE_FLAG VARCHAR2 (1)
RESERVABLE_FLAG VARCHAR2 (1)
UNIT_CODE VARCHAR2 (3)
RELEASED_FLAG VARCHAR2 (1) Yes
REQUIRED_FOR_REVENUE_FLAG VARCHAR2 (1)
QUANTITY NUMBER
Yes
WAREHOUSE_ID NUMBER

DEMAND_CLASS_CODE VARCHAR2 (30)
SCHEDULE_DATE DATE

REVISION VARCHAR2 (3)
LOT_NUMBER VARCHAR2 (30)
SUBINVENTORY VARCHAR2 (10)
CUSTOMER_REQUESTED_LOT_FLAG VARCHAR2 (1)
SCHEDULE_STATUS_CODE VARCHAR2 (30)
RECEIPT_STATUS_CODE VARCHAR2 (30)
SCHEDULE_LEVEL_CODE NUMBER

QUANTITY_SVRID NUMBER

WAREHOUSE_SVRID NUMBER

DEMAND_CLASS_SVRID NUMBER

DATE_SVRID NUMBER

REVISION_SVRID NUMBER

LOT_SVRID NUMBER

SUBINVENTORY_SVRID NUMBER

CUSTOMER_REQUESTED_SVRID NUMBER

DF_SVRID NUMBER

CONTEXT VARCHAR2 (30)
ATTRIBUTE1 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)
ATTRIBUTE10 VARCHAR2 (150)
ATTRIBUTE11 VARCHAR2 (150)
ATTRIBUTE12 VARCHAR2 (150)
ATTRIBUTE13 VARCHAR2 (150)
ATTRIBUTE14 VARCHAR2 (150)
ATTRIBUTE15 VARCHAR2 (150)
DELIVERY NUMBER

WIP_RESERVED_QUANTITY NUMBER

WIP_COMPLETED_QUANTITY NUMBER

SUPPLY_SOURCE_TYPE NUMBER

SUPPLY_SOURCE_HEADER_ID NUMBER

UPDATE_FLAG VARCHAR2 (1)
INVENTORY_LOCATION_ID NUMBER

CONFIGURATION_ITEM_FLAG VARCHAR2 (1)
LATEST_ACCEPTABLE_DATE DATE

LATEST_ACCEPTABLE_DATE_SVRID NUMBER

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)
RECEIPT_STATUS VARCHAR2 (80)
DEP_PLAN_REQUIRED_FLAG VARCHAR2 (1)
DPW_ASSIGNED_FLAG VARCHAR2 (1)
DELIVERY_ID NUMBER

DEPARTURE_ID NUMBER

CUSTOMER_ITEM_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 ROW_ID
,      LINE_DETAIL_ID
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      LINE_ID
,      INVENTORY_ITEM_ID
,      INCLUDED_ITEM_FLAG
,      COMPONENT_SEQUENCE_ID
,      COMPONENT_CODE
,      COMPONENT_RATIO
,      SHIPPABLE_FLAG
,      TRANSACTABLE_FLAG
,      RESERVABLE_FLAG
,      UNIT_CODE
,      RELEASED_FLAG
,      REQUIRED_FOR_REVENUE_FLAG
,      QUANTITY
,      WAREHOUSE_ID
,      DEMAND_CLASS_CODE
,      SCHEDULE_DATE
,      REVISION
,      LOT_NUMBER
,      SUBINVENTORY
,      CUSTOMER_REQUESTED_LOT_FLAG
,      SCHEDULE_STATUS_CODE
,      RECEIPT_STATUS_CODE
,      SCHEDULE_LEVEL_CODE
,      QUANTITY_SVRID
,      WAREHOUSE_SVRID
,      DEMAND_CLASS_SVRID
,      DATE_SVRID
,      REVISION_SVRID
,      LOT_SVRID
,      SUBINVENTORY_SVRID
,      CUSTOMER_REQUESTED_SVRID
,      DF_SVRID
,      CONTEXT
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      DELIVERY
,      WIP_RESERVED_QUANTITY
,      WIP_COMPLETED_QUANTITY
,      SUPPLY_SOURCE_TYPE
,      SUPPLY_SOURCE_HEADER_ID
,      UPDATE_FLAG
,      INVENTORY_LOCATION_ID
,      CONFIGURATION_ITEM_FLAG
,      LATEST_ACCEPTABLE_DATE
,      LATEST_ACCEPTABLE_DATE_SVRID
,      WAREHOUSE
,      REVISION_CONTROL_FLAG
,      LOT_CONTROL_FLAG
,      INVENTORY_ASSET_FLAG
,      ITEM
,      ITEM_DESCRIPTION
,      RESTRICT_SUBINVENTORIES_CODE
,      SCHEDULE_STATUS
,      RECEIPT_STATUS
,      DEP_PLAN_REQUIRED_FLAG
,      DPW_ASSIGNED_FLAG
,      DELIVERY_ID
,      DEPARTURE_ID
,      CUSTOMER_ITEM_ID
,      LOAD_SEQ_NUMBER
,      MASTER_CONTAINER_ITEM_ID
,      DETAIL_CONTAINER_ITEM_ID
FROM APPS.SO_LINE_DETAILS_V;

Dependencies

[top of page]

APPS.SO_LINE_DETAILS_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
ViewMTL_SYSTEM_ITEMS_VL
SynonymSO_LINE_DETAILS
SynonymSO_LOOKUPS

APPS.SO_LINE_DETAILS_V is not referenced by any database object