[Home] [Help] [Dependency Information]
Object Name: | EAM_BILL_BY_REQUIREMENTS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | EAM.EAM_BILL_BY_REQUIREMENTS_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 | Work Order Id | ||
ORGANIZATION_ID | NUMBER | Inventory Organization Id | ||
OP_SEQ_NUM | NUMBER | Operation Sequence Number within the Work Order | ||
ITEM_RESOURCE_ID | NUMBER | Item Resource Id | ||
ITEM_RESOURCE_NAME | VARCHAR2 | (40) | Item Resource Name | |
TYPE | NUMBER | Internal Type | ||
UOM | VARCHAR2 | (3) | Unit Of Measure | |
APPLIED_QUANTITY | NUMBER | Quantity Applied or used against the work order. | ||
BILLED_QUANTITY | NUMBER | Quantity billed | ||
BILL_INVENTORY_ITEM_ID | NUMBER | Billable Item Id | ||
BILL_UOM | VARCHAR2 | (3) | Billable Unit of Measure | |
BILL_QUANTITY | NUMBER | Billable Quantity | ||
BILLING_METHOD | NUMBER | Billing Method: 1=Bill By Requirements, 2=Bill By Activity 3=Capitalization |
Cut, paste (and edit) the following text to query this object:
SELECT WIP_ENTITY_ID
, ORGANIZATION_ID
, OP_SEQ_NUM
, ITEM_RESOURCE_ID
, ITEM_RESOURCE_NAME
, TYPE
, UOM
, APPLIED_QUANTITY
, BILLED_QUANTITY
, BILL_INVENTORY_ITEM_ID
, BILL_UOM
, BILL_QUANTITY
, BILLING_METHOD
FROM APPS.EAM_BILL_BY_REQUIREMENTS_V;
APPS.EAM_BILL_BY_REQUIREMENTS_V is not referenced by any database object
|
|
|