View: EAM_BILL_BY_ACTIVITIES_V

Product:	EAM - Enterprise Asset Management
Description:	A view used to simplify forms coding. Used for getting information for the bill by activities block.
Implementation/DBA Data:	APPS.EAM_BILL_BY_ACTIVITIES_V

View Text

SELECT WDJ.WIP_ENTITY_ID WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID ORGANIZATION_ID
, WDJ.PRIMARY_ITEM_ID ACTIVITY_ID
, NVL(SUM(EWOB.BILLED_QUANTITY)
, 0) BILLED_QUANTITY
, DECODE(MSI.INVOICE_ENABLED_FLAG
, 'Y'
, DECODE(WEP.INVOICE_BILLABLE_ITEMS_ONLY
, 'Y'
, DECODE(MATERIAL_BILLABLE_FLAG
, 'M'
, WDJ.PRIMARY_ITEM_ID
, NULL)
, WDJ.PRIMARY_ITEM_ID)
, NULL) BILL_INVENTORY_ITEM_ID
, MSI.PRIMARY_UOM_CODE BILL_UOM
, 1 - NVL(SUM(EWOB.BILLED_QUANTITY)
, 0) BILL_QUANTITY
, MSI.DESCRIPTION ACTIVITY_DESCRIPTION
, ML1.MEANING ACTIVITY_TYPE
, ML2.MEANING ACTIVITY_SOURCE
, ML3.MEANING ACTIVITY_CAUSE
FROM EAM_WORK_ORDER_BILLS EWOB
, WIP_EAM_PARAMETERS WEP
, WIP_DISCRETE_JOBS WDJ
, MTL_SYSTEM_ITEMS MSI
, MFG_LOOKUPS ML1
, MFG_LOOKUPS ML2
, MFG_LOOKUPS ML3
WHERE WDJ.WIP_ENTITY_ID = EWOB.WIP_ENTITY_ID(+)
AND WDJ.ORGANIZATION_ID = EWOB.ORGANIZATION_ID(+)
AND EWOB.BILLING_METHOD(+) = 2
AND WEP.ORGANIZATION_ID(+) = WDJ.ORGANIZATION_ID
AND MSI.ORGANIZATION_ID = WDJ.ORGANIZATION_ID
AND MSI.INVENTORY_ITEM_ID = WDJ.PRIMARY_ITEM_ID
AND ML1.LOOKUP_CODE(+) = WDJ.ACTIVITY_TYPE
AND ML1.LOOKUP_TYPE(+) = 'MTL_EAM_ACTIVITY_TYPE'
AND ML2.LOOKUP_CODE(+) = WDJ.ACTIVITY_CAUSE
AND ML2.LOOKUP_TYPE(+) = 'MTL_EAM_ACTIVITY_CAUSE'
AND ML3.LOOKUP_CODE(+) = WDJ.ACTIVITY_SOURCE
AND ML3.LOOKUP_TYPE(+) = 'MTL_EAM_ACTIVITY_SOURCE' GROUP BY WDJ.WIP_ENTITY_ID
, WDJ.ORGANIZATION_ID
, WDJ.PRIMARY_ITEM_ID
, DECODE(MSI.INVOICE_ENABLED_FLAG
, 'Y'
, DECODE(WEP.INVOICE_BILLABLE_ITEMS_ONLY
, 'Y'
, DECODE(MATERIAL_BILLABLE_FLAG
, 'M'
, WDJ.PRIMARY_ITEM_ID
, NULL)
, WDJ.PRIMARY_ITEM_ID)
, NULL)
, MSI.PRIMARY_UOM_CODE
, MSI.DESCRIPTION
, ML1.MEANING
, ML2.MEANING
, ML3.MEANING

Columns