[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | EAM_WORK_ORDER_BILL_DETAILS_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  EAM.EAM_WORK_ORDER_BILL_DETAILS_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 |
|---|---|---|---|---|
| ORGANIZATION_ID | NUMBER | (38) | Yes | Organization Id |
| CUSTOMER_ID | NUMBER | (38) | Customer Id | |
| CUSTOMER_NAME | VARCHAR2 | (360) | Yes | Customer Name |
| BILL_TO_ADDRESS_ID | NUMBER | (38) | Customer Bill Address Id | |
| WIP_ENTITY_ID | NUMBER | (38) | Yes | Work Order Id |
| WIP_ENTITY_NAME | VARCHAR2 | (240) | Yes | Work Order Name |
| OPERATION_SEQ_NUM | NUMBER | (38) | Operation Sequence Number of Work Order | |
| LAST_UPDATE_DATE | DATE | Yes | Standard Who Column | |
| LAST_UPDATED_BY | NUMBER | (38) | Yes | Standard Who Column |
| CREATION_DATE | DATE | Yes | Standard Who Column | |
| CREATED_BY | NUMBER | (38) | Yes | Standard Who Column |
| LAST_UPDATE_LOGIN | NUMBER | (38) | Standard Who Column | |
| INVENTORY_ITEM_ID | NUMBER | (38) | Item Id | |
| RESOURCE_ID | NUMBER | (38) | Resource Id | |
| BILLED_INVENTORY_ITEM_ID | NUMBER | (38) | Yes | Billed Item Id |
| BILLED_UOM_CODE | VARCHAR2 | (3) | Billed Unit of Measure Code | |
| BILLED_QUANTITY | NUMBER | Billed Quantity | ||
| BILLING_BASIS | NUMBER | (38) | Billing Basis | |
| PRICE_LIST_HEADER_ID | NUMBER | (38) | Price List Header Id | |
| COST_TYPE_ID | NUMBER | (38) | Cost Type Id | |
| COST_OR_LISTPRICE | NUMBER | (38) | Unit Price of Billed Item | |
| COSTPLUS_PERCENTAGE | NUMBER | (38) | Cost Plus Markup | |
| BILLED_AMOUNT | NUMBER | Billed Amount | ||
| REF_INVOICE_TRX_NUMBER | NUMBER | (38) | Reference Invoice header | |
| REF_INVOICE_LINE_NUMBER | NUMBER | (38) | Reference Invoice Line Number | |
| CURRENCY_CODE | VARCHAR2 | (15) | Bill Currency Code | |
| CONVERSION_RATE | NUMBER | (38) | Currency Conversion Rate | |
| CONVERSION_TYPE_CODE | VARCHAR2 | (30) | Currency Conversion Type Code | |
| CONVERSION_RATE_DATE | DATE | Date on which currency conversion done | ||
| PROJECT_ID | NUMBER | (38) | Contract Project Id | |
| PROJECT_NAME | VARCHAR2 | (30) | Contract Project Name | |
| TASK_ID | NUMBER | (38) | Contract Project Task Id | |
| TASK_NAME | VARCHAR2 | (20) | Contract Project Task Name | |
| WORK_REQUEST_ID | NUMBER | (38) | Maintenance Work Request Id | |
| PA_EVENT_ID | NUMBER | (38) | Project Accounting Event Id | |
| BILLED_DATE | DATE | Yes | Billed Date | |
| INVOICE_DATE | DATE | Invoice Date | ||
| TRX_NUMBER | VARCHAR2 | (20) | Invoice Transaction Number | |
| LINE_NUMBER | NUMBER | Invoice Line Number |
Cut, paste (and edit) the following text to query this object:
SELECT ORGANIZATION_ID
, CUSTOMER_ID
, CUSTOMER_NAME
, BILL_TO_ADDRESS_ID
, WIP_ENTITY_ID
, WIP_ENTITY_NAME
, OPERATION_SEQ_NUM
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, INVENTORY_ITEM_ID
, RESOURCE_ID
, BILLED_INVENTORY_ITEM_ID
, BILLED_UOM_CODE
, BILLED_QUANTITY
, BILLING_BASIS
, PRICE_LIST_HEADER_ID
, COST_TYPE_ID
, COST_OR_LISTPRICE
, COSTPLUS_PERCENTAGE
, BILLED_AMOUNT
, REF_INVOICE_TRX_NUMBER
, REF_INVOICE_LINE_NUMBER
, CURRENCY_CODE
, CONVERSION_RATE
, CONVERSION_TYPE_CODE
, CONVERSION_RATE_DATE
, PROJECT_ID
, PROJECT_NAME
, TASK_ID
, TASK_NAME
, WORK_REQUEST_ID
, PA_EVENT_ID
, BILLED_DATE
, INVOICE_DATE
, TRX_NUMBER
, LINE_NUMBER
FROM APPS.EAM_WORK_ORDER_BILL_DETAILS_V;
APPS
EAM_WORK_ORDER_BILLS
HZ_CUST_ACCOUNTS
HZ_PARTIES
PA_PROJECTS_ALL
PA_TASKS
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
WIP_ENTITIES
APPS.EAM_WORK_ORDER_BILL_DETAILS_V is not referenced by any database object
|
|
|
|