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

VIEW: APPS.AHL_OSP_ORDER_LINES_V

Object Details
Object Name: AHL_OSP_ORDER_LINES_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewAHL.AHL_OSP_ORDER_LINES_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
Name Datatype Length Mandatory Comments
OSP_ORDER_LINE_ID NUMBER

Internal Identifier for OSP Order Line ID.
OBJECT_VERSION_NUMBER NUMBER

Record version number.
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
CREATED_BY NUMBER

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
OSP_ORDER_ID NUMBER

OSP Order ID
OSP_ORDER_NUMBER NUMBER

OSP_LINE_NUMBER NUMBER

OSP Line Number
STATUS_CODE VARCHAR2 (30)
OSP Order Line status code.
STATUS VARCHAR2 (80)
OSP Order Line status meaning.
NEED_BY_DATE DATE

Need By Date
SHIP_BY_DATE DATE

Ship By Date
PO_LINE_ID NUMBER

PO Line ID
PO_LINE_TYPE_ID NUMBER

PO Line Type ID
PO_LINE_TYPE VARCHAR2 (25)
PO Line type retreived from PO LINE TYPES table corresponding to the PO Line ID.
OE_SHIP_LINE_ID NUMBER

OE Shipment Line ID
OE_RETURN_LINE_ID NUMBER

OD Return Line ID
SERVICE_ITEM_ID NUMBER

Service Item ID
SERVICE_ITEM_DESCRIPTION VARCHAR2 (2000)
Description of the Service Item
SERVICE_ITEM_NUMBER VARCHAR2 (40)
Service Item Number
SERVICE_ITEM_UOM_CODE VARCHAR2 (3)
Unit Of Measure of the Service Item.
QUANTITY NUMBER

Quantity of Work Orders.
WORKORDER_ID NUMBER

Workorder ID
OPERATION_ID NUMBER

Operation ID
JOB_NUMBER VARCHAR2 (80)
Job Number
ITEM_INSTANCE_ID NUMBER

Item Instance Id
ITEM_INSTANCE_NUMBER VARCHAR2 (30)
Item Instance Number
PROJECT_ID NUMBER

Project Id associated to Work Order
PROJECT_NAME VARCHAR2 (30)
Project Name associated to Work Order.
PROJECT_TASK_ID NUMBER

Project Task Id assocaited to Work Order.
PROJECT_TASK_NAME VARCHAR2 (20)
Project Task Name assocaited to Work Order.
WO_SERVICE_ITEM_ID NUMBER

Service Item Id of the associated Work Order. May be different from the OSP Line's Service Item Id
SUB_INVENTORY VARCHAR2 (10)
INVENTORY_ITEM_ID NUMBER

INVENTORY_ORG_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
ITEM_DESCRIPTION VARCHAR2 (240)
SERIAL_NUMBER VARCHAR2 (30)
Serial Number assocaited to Work Order.
LOT_NUMBER VARCHAR2 (80)
INVENTORY_ITEM_UOM VARCHAR2 (3)
INVENTORY_ITEM_QUANTITY NUMBER

EXCHANGE_INSTANCE_ID NUMBER

EXCHANGE_INSTANCE_NUMBER VARCHAR2 (30)
EXCHANGE_ITEM_ID NUMBER

EXCHANGE_ITEM_NUMBER VARCHAR2 (40)
EXCHANGE_INSTANCE_SL_NO VARCHAR2 (30)
Exchange Instance Serial Number
PO_REQ_LINE_ID NUMBER

FK to PO_REQUISITION_LINES_ALL
SECURITY_GROUP_ID NUMBER

Security Group ID
ATTRIBUTE_CATEGORY VARCHAR2 (30)
Descriptive flexfield structure defining 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
Query Text

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


SELECT OSP_ORDER_LINE_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OSP_ORDER_ID
,      OSP_ORDER_NUMBER
,      OSP_LINE_NUMBER
,      STATUS_CODE
,      STATUS
,      NEED_BY_DATE
,      SHIP_BY_DATE
,      PO_LINE_ID
,      PO_LINE_TYPE_ID
,      PO_LINE_TYPE
,      OE_SHIP_LINE_ID
,      OE_RETURN_LINE_ID
,      SERVICE_ITEM_ID
,      SERVICE_ITEM_DESCRIPTION
,      SERVICE_ITEM_NUMBER
,      SERVICE_ITEM_UOM_CODE
,      QUANTITY
,      WORKORDER_ID
,      OPERATION_ID
,      JOB_NUMBER
,      ITEM_INSTANCE_ID
,      ITEM_INSTANCE_NUMBER
,      PROJECT_ID
,      PROJECT_NAME
,      PROJECT_TASK_ID
,      PROJECT_TASK_NAME
,      WO_SERVICE_ITEM_ID
,      SUB_INVENTORY
,      INVENTORY_ITEM_ID
,      INVENTORY_ORG_ID
,      ITEM_NUMBER
,      ITEM_DESCRIPTION
,      SERIAL_NUMBER
,      LOT_NUMBER
,      INVENTORY_ITEM_UOM
,      INVENTORY_ITEM_QUANTITY
,      EXCHANGE_INSTANCE_ID
,      EXCHANGE_INSTANCE_NUMBER
,      EXCHANGE_ITEM_ID
,      EXCHANGE_ITEM_NUMBER
,      EXCHANGE_INSTANCE_SL_NO
,      PO_REQ_LINE_ID
,      SECURITY_GROUP_ID
,      ATTRIBUTE_CATEGORY
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
FROM APPS.AHL_OSP_ORDER_LINES_V;

Dependencies

[top of page]

APPS.AHL_OSP_ORDER_LINES_V references the following:

SchemaAPPS
SynonymAHL_OSP_ORDERS_B
SynonymAHL_OSP_ORDER_LINES
ViewAHL_WORKORDERS_OSP_V
SynonymCSI_ITEM_INSTANCES
ViewFND_LOOKUP_VALUES_VL
PL/SQL PackageHR_GENERAL - show dependent code
PL/SQL PackageHR_SECURITY - show dependent code
PL/SQL PackageMO_GLOBAL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymPO_LINE_TYPES
APPS.AHL_OSP_ORDER_LINES_V is referenced by following:

SchemaAPPS
Package BodyAHL_RA_ANALYSER_PVT - show dependent code