VIEW: APPS.CSL_MTL_EXPENSE_LABOR_ITEMS_V

Source

View Text - Preformatted

SELECT B.INVENTORY_ITEM_ID , B.ORGANIZATION_ID , B.ENABLED_FLAG , B.START_DATE_ACTIVE , B.END_DATE_ACTIVE , B.PRIMARY_UOM_CODE , B.SERVICE_ITEM_FLAG , B.SERVICEABLE_PRODUCT_FLAG , B.MATERIAL_BILLABLE_FLAG , B.RETURNABLE_FLAG , B.LIST_PRICE_PER_UNIT , B.MTL_TRANSACTIONS_ENABLED_FLAG , KFV.CONCATENATED_SEGMENTS , B.SERIAL_NUMBER_CONTROL_CODE , B.LOT_CONTROL_CODE , B.INVENTORY_ASSET_FLAG , B.PURCHASING_ENABLED_FLAG , B.INTERNAL_ORDER_ENABLED_FLAG , B.INTERNAL_ORDER_FLAG , B.PURCHASING_ITEM_FLAG , B.COMMS_NL_TRACKABLE_FLAG , B.SERV_REQ_ENABLED_CODE , TL.DESCRIPTION , TL.LANGUAGE , B.ATTRIBUTE1 , B.ATTRIBUTE2 , B.ATTRIBUTE3 , B.ATTRIBUTE4 , B.ATTRIBUTE5 , B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.ATTRIBUTE_CATEGORY , A.ACCESS_ID FROM MTL_SYSTEM_ITEMS_B B , MTL_SYSTEM_ITEMS_KFV KFV , MTL_SYSTEM_ITEMS_TL TL , JTM_MTL_SYSTEM_ITEMS_ACC A , CS_BILLING_TYPE_CATEGORIES cbtc WHERE B.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = KFV.ORGANIZATION_ID AND B.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = A.ORGANIZATION_ID AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID AND B.MATERIAL_BILLABLE_FLAG = CBTC.BILLING_TYPE (+) AND NVL(CBTC.BILLING_CATEGORY, 'M') IN ('E','L')

View Text - HTML Formatted

SELECT B.INVENTORY_ITEM_ID
, B.ORGANIZATION_ID
, B.ENABLED_FLAG
, B.START_DATE_ACTIVE
, B.END_DATE_ACTIVE
, B.PRIMARY_UOM_CODE
, B.SERVICE_ITEM_FLAG
, B.SERVICEABLE_PRODUCT_FLAG
, B.MATERIAL_BILLABLE_FLAG
, B.RETURNABLE_FLAG
, B.LIST_PRICE_PER_UNIT
, B.MTL_TRANSACTIONS_ENABLED_FLAG
, KFV.CONCATENATED_SEGMENTS
, B.SERIAL_NUMBER_CONTROL_CODE
, B.LOT_CONTROL_CODE
, B.INVENTORY_ASSET_FLAG
, B.PURCHASING_ENABLED_FLAG
, B.INTERNAL_ORDER_ENABLED_FLAG
, B.INTERNAL_ORDER_FLAG
, B.PURCHASING_ITEM_FLAG
, B.COMMS_NL_TRACKABLE_FLAG
, B.SERV_REQ_ENABLED_CODE
, TL.DESCRIPTION
, TL.LANGUAGE
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.ATTRIBUTE_CATEGORY
, A.ACCESS_ID
FROM MTL_SYSTEM_ITEMS_B B
, MTL_SYSTEM_ITEMS_KFV KFV
, MTL_SYSTEM_ITEMS_TL TL
, JTM_MTL_SYSTEM_ITEMS_ACC A
, CS_BILLING_TYPE_CATEGORIES CBTC
WHERE B.INVENTORY_ITEM_ID = KFV.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = KFV.ORGANIZATION_ID
AND B.INVENTORY_ITEM_ID = A.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = A.ORGANIZATION_ID
AND B.INVENTORY_ITEM_ID = TL.INVENTORY_ITEM_ID
AND B.ORGANIZATION_ID = TL.ORGANIZATION_ID
AND TL.LANGUAGE = ASG_BASE.GET_LANGUAGE
AND A.RESOURCE_ID = ASG_BASE.GET_RESOURCE_ID
AND B.MATERIAL_BILLABLE_FLAG = CBTC.BILLING_TYPE (+)
AND NVL(CBTC.BILLING_CATEGORY
, 'M') IN ('E'
, 'L')