[Home] [Help] [Dependency Information]
Object Name: | EAM_BILL_BY_ACTIVITIES_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_BILL_BY_ACTIVITIES_V |
Subobject Name: | |
Status: | VALID |
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.
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
WIP_ENTITY_ID | NUMBER | Yes | Work Order Id | |
ORGANIZATION_ID | NUMBER | Yes | Inventory Organization id | |
ACTIVITY_ID | NUMBER | Maintenance Activity against which this work order is cut | ||
BILLED_QUANTITY | NUMBER | Billed Quantity | ||
BILL_INVENTORY_ITEM_ID | NUMBER | Id of Item desired to be billed | ||
BILL_UOM | VARCHAR2 | (3) | ||
BILL_QUANTITY | NUMBER | Unit of Measure Code for billed item | ||
ACTIVITY_DESCRIPTION | VARCHAR2 | (240) | Maintenance Activity Description | |
ACTIVITY_TYPE | VARCHAR2 | (80) | Maintenance Activity Type | |
ACTIVITY_SOURCE | VARCHAR2 | (80) | Maintenance Activity Source | |
ACTIVITY_CAUSE | VARCHAR2 | (80) | Maintenance Activity Cause |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, ORGANIZATION_ID
, ACTIVITY_ID
, BILLED_QUANTITY
, BILL_INVENTORY_ITEM_ID
, BILL_UOM
, BILL_QUANTITY
, ACTIVITY_DESCRIPTION
, ACTIVITY_TYPE
, ACTIVITY_SOURCE
, ACTIVITY_CAUSE
FROM APPS.EAM_BILL_BY_ACTIVITIES_V;
APPS.EAM_BILL_BY_ACTIVITIES_V is not referenced by any database object
|
|
|