[Home] [Help] [Dependency Information]
Object Name: | EAM_CAPT_BILL_BY_REQ_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
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 | Stores the Work Order ID | ||
ORGANIZATION_ID | NUMBER | Stores the Inventory Organization ID | ||
OP_SEQ_NUM | NUMBER | Operation Sequence Number within Work Order | ||
ITEM_RESOURCE_ID | NUMBER | Stores the resource id | ||
ITEM_RESOURCE_NAME | VARCHAR2 | (240) | Item Resource Name | |
TYPE | NUMBER | Column to identity whether a the entity is an item(type=1), resource(type=2) or direct item(type=3) | ||
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_CAPT_BILL_BY_REQ_V;
APPS.EAM_CAPT_BILL_BY_REQ_V is not referenced by any database object
|
|
|