eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

VIEW: APPS.EAM_CAPT_BILL_BY_REQ_V

Object Details

Object Name:	EAM_CAPT_BILL_BY_REQ_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	EAM.EAM_CAPT_BILL_BY_REQ_V
Subobject Name:
Status:	VALID

View Type

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.

[View Source]

Columns

Name	Datatype	Length	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

Query Text

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;

Dependencies

[top of page]

APPS.EAM_CAPT_BILL_BY_REQ_V references the following:

APPS: BOM_RESOURCES; EAM_DIRECT_ITEM_RECS_V; EAM_WORK_ORDER_BILLS; FND_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS_KFV; WIP_EAM_PARAMETERS; WIP_OPERATION_RESOURCES; WIP_REQUIREMENT_OPERATIONS

APPS.EAM_CAPT_BILL_BY_REQ_V is not referenced by any database object