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.
[Home] [Help]
View: EAM_CAPT_BILL_BY_REQ_V
Product: EAM - Enterprise Asset Management
Description: This view will be used to display the materials, direct items and resources of a work order. It is essentially a union of eam_bill_by_requirements_v and direct items view.Note that for direct items, we are fetching only those records from e
Implementation/DBA Data:
APPS.EAM_CAPT_BILL_BY_REQ_V
View Text
SELECT WRO.WIP_ENTITY_ID WIP_ENTITY_ID , WRO.ORGANIZATION_ID ORGANIZATION_ID , WRO.OPERATION_SEQ_NUM OP_SEQ_NUM , WRO.INVENTORY_ITEM_ID ITEM_RESOURCE_ID , MSI.CONCATENATED_SEGMENTS ITEM_RESOURCE_NAME , 1 TYPE , MSI.PRIMARY_UOM_CODE UOM , WRO.QUANTITY_ISSUED APPLIED_QUANTITY , NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILLED_QUANTITY , WRO.INVENTORY_ITEM_ID BILL_INVENTORY_ITEM_ID , MSI.PRIMARY_UOM_CODE BILL_UOM , WRO.QUANTITY_ISSUED - NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILL_QUANTITY , EWOB.BILLING_METHOD FROM ( SELECT * FROM EAM_WORK_ORDER_BILLS WHERE BILLING_METHOD = 3 ) EWOB , WIP_EAM_PARAMETERS WEP , WIP_REQUIREMENT_OPERATIONS WRO , MTL_SYSTEM_ITEMS_KFV MSI WHERE WRO.WIP_ENTITY_ID = EWOB.WIP_ENTITY_ID(+) AND WEP.ORGANIZATION_ID(+) = EWOB.ORGANIZATION_ID AND WRO.ORGANIZATION_ID = EWOB.ORGANIZATION_ID(+) AND WRO.OPERATION_SEQ_NUM = EWOB.OPERATION_SEQ_NUM(+) AND WRO.INVENTORY_ITEM_ID = EWOB.INVENTORY_ITEM_ID(+) AND MSI.ORGANIZATION_ID = WRO.ORGANIZATION_ID AND MSI.INVENTORY_ITEM_ID = WRO.INVENTORY_ITEM_ID GROUP BY WRO.WIP_ENTITY_ID , WRO.ORGANIZATION_ID , WRO.OPERATION_SEQ_NUM , WRO.INVENTORY_ITEM_ID , MSI.CONCATENATED_SEGMENTS , 1 , MSI.PRIMARY_UOM_CODE , WRO.QUANTITY_ISSUED , WRO.INVENTORY_ITEM_ID , EWOB.BILLING_METHOD UNION SELECT WOR.WIP_ENTITY_ID WIP_ENTITY_ID , WOR.ORGANIZATION_ID ORGANIZATION_ID , WOR.OPERATION_SEQ_NUM OP_SEQ_NUM , WOR.RESOURCE_ID ITEM_RESOURCE_ID , BR.RESOURCE_CODE ITEM_RESOURCE_NAME , 2 TYPE , WOR.UOM_CODE UOM , WOR.APPLIED_RESOURCE_UNITS APPLIED_QUANTITY , NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILLED_QUANTITY , NULL BILL_INVENTORY_ITEM_ID , NULL BILL_UOM , WOR.APPLIED_RESOURCE_UNITS - NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILL_QUANTITY , EWOB.BILLING_METHOD FROM ( SELECT * FROM EAM_WORK_ORDER_BILLS WHERE BILLING_METHOD = 3 ) EWOB , WIP_OPERATION_RESOURCES WOR , BOM_RESOURCES BR WHERE WOR.WIP_ENTITY_ID = EWOB.WIP_ENTITY_ID(+) AND WOR.ORGANIZATION_ID = EWOB.ORGANIZATION_ID(+) AND WOR.OPERATION_SEQ_NUM = EWOB.OPERATION_SEQ_NUM(+) AND WOR.RESOURCE_ID = EWOB.RESOURCE_ID(+) AND BR.ORGANIZATION_ID = WOR.ORGANIZATION_ID AND BR.RESOURCE_ID = WOR.RESOURCE_ID GROUP BY WOR.WIP_ENTITY_ID , WOR.ORGANIZATION_ID , WOR.OPERATION_SEQ_NUM , WOR.RESOURCE_ID , BR.RESOURCE_CODE , 2 , WOR.UOM_CODE , WOR.APPLIED_RESOURCE_UNITS , NULL , NULL , EWOB.BILLING_METHOD UNION SELECT EDIRV.WIP_ENTITY_ID WIP_ENTITY_ID , EDIRV.ORGANIZATION_ID ORGANIZATION_ID , EDIRV.TASK_NUMBER OP_SEQ_NUM , NVL(EDIRV.INVENTORY_ITEM_ID , EDIRV.DIRECT_ITEM_SEQUENCE_ID) ITEM_RESOURCE_ID , NVL(EDIRV.ITEM_DESCRIPTION , EDIRV.DESCRIPTION) ITEM_RESOURCE_NAME , 3 TYPE , EDIRV.UOM_CODE UOM , EDIRV.QUANTITY_RECEIVED APPLIED_QUANTITY , NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILLED_QUANTITY , EDIRV.INVENTORY_ITEM_ID BILL_INVENTORY_ITEM_ID , EDIRV.UOM_CODE BILL_UOM , EDIRV.QUANTITY_RECEIVED - NVL(SUM(EWOB.BILLED_QUANTITY) , 0) BILL_QUANTITY , 3 BILLING_METHOD FROM EAM_WORK_ORDER_BILLS EWOB , EAM_DIRECT_ITEM_RECS_V EDIRV WHERE EDIRV.WIP_ENTITY_ID = EWOB.WIP_ENTITY_ID(+) AND EDIRV.ORGANIZATION_ID = EWOB.ORGANIZATION_ID(+) AND EDIRV.TASK_NUMBER = EWOB.OPERATION_SEQ_NUM(+) AND NVL(EDIRV.INVENTORY_ITEM_ID , EDIRV.DIRECT_ITEM_SEQUENCE_ID) = EWOB.RESOURCE_ID (+) AND EWOB.BILLING_METHOD(+) = 3 GROUP BY EDIRV.WIP_ENTITY_ID , EDIRV.ORGANIZATION_ID , EDIRV.TASK_NUMBER , EDIRV.INVENTORY_ITEM_ID , EDIRV.DIRECT_ITEM_SEQUENCE_ID , EDIRV.ITEM_DESCRIPTION , EDIRV.DESCRIPTION , 3 , EDIRV.QUANTITY_RECEIVED , EDIRV.UOM_CODE , EWOB.BILLING_METHOD
Columns
Name
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