VIEW: APPS.CSF_DEBRIEF_EXP_LINES_V

Source

View Text - Preformatted

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 (+)

View Text - HTML Formatted

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 (+)