View: CSF_DEBRIEF_EXP_LINES_V

Product:	CSF - Field Service
Description:	Field Service Report Expense lines information
Implementation/DBA Data:	APPS.CSF_DEBRIEF_EXP_LINES_V

View Text

SELECT CDL.ROWID
, CDL.CHANNEL_CODE
, CDL.DEBRIEF_LINE_ID
, CDL.DEBRIEF_HEADER_ID
, CDL.SERVICE_DATE
, CDL.INVENTORY_ITEM_ID
, CDL.UOM_CODE
, CDL.QUANTITY
, CDL.EXPENSE_AMOUNT
, CDL.CURRENCY_CODE
, CDL.CREATED_BY
, CDL.CREATION_DATE
, CDL.LAST_UPDATED_BY
, CDL.LAST_UPDATE_DATE
, CDL.LAST_UPDATE_LOGIN
, CDL.ATTRIBUTE1
, CDL.ATTRIBUTE2
, CDL.ATTRIBUTE3
, CDL.ATTRIBUTE4
, CDL.ATTRIBUTE5
, CDL.ATTRIBUTE6
, CDL.ATTRIBUTE7
, CDL.ATTRIBUTE8
, CDL.ATTRIBUTE9
, CDL.ATTRIBUTE10
, CDL.ATTRIBUTE11
, CDL.ATTRIBUTE12
, CDL.ATTRIBUTE13
, CDL.ATTRIBUTE14
, CDL.ATTRIBUTE15
, CDL.ATTRIBUTE_CATEGORY
, CDL.EXPENSE_REASON_CODE
, CDL.BUSINESS_PROCESS_ID
, CTT.TRANSACTION_TYPE_ID
, CTT.NAME
, FL.MEANING
, CDL.CHARGE_UPLOAD_STATUS
, CDL.CHARGE_UPLOAD_MSG_CODE
, CDL.CHARGE_UPLOAD_MESSAGE
, CDL.ERROR_TEXT
FROM CSF_DEBRIEF_LINES CDL
, CS_TRANSACTION_TYPES CTT
, FND_LOOKUPS FL
, MTL_SYSTEM_ITEMS_B_KFV MSIBK
, CS_BILLING_TYPE_CATEGORIES CBTC
WHERE CTT.TRANSACTION_TYPE_ID = CDL.TRANSACTION_TYPE_ID
AND MSIBK.MATERIAL_BILLABLE_FLAG = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY = 'E'
AND MSIBK.INVENTORY_ITEM_ID = CDL.INVENTORY_ITEM_ID
AND MSIBK.ORGANIZATION_ID = CS_STD.GET_ITEM_VALDN_ORGZN_ID
AND FL.LOOKUP_TYPE (+) = 'CSF_EXPENSE_REASON'
AND CDL.EXPENSE_REASON_CODE = FL.LOOKUP_CODE (+)

Columns