VIEW: APPS.CSF_M_DEBRIEF_EXPENSES_V

Source

View Text - Preformatted

SELECT CSM_UTIL_PKG.GET_NUMBER(acc.access_id), lines.debrief_line_id, lines.inventory_item_id, lines.txn_billing_type_id,CSM_UTIL_PKG.GET_NUMBER( header.task_assignment_id) , asg_base.get_resource_id, lines.quantity , lines.expense_amount , lines.currency_code, lines.uom_code, lines.business_process_id, CSM_UTIL_PKG.GET_DATE(lines.last_update_date), csm_util_pkg.item_name(msi.concatenated_segments) AS item_name, msi.description AS item_description, lines.transaction_type_id ,CSM_UTIL_PKG.GET_DATE(lines.service_date), lines.expense_reason_code, lines.attribute1, lines.attribute2, lines.attribute3, lines.attribute4, lines.attribute5, lines.attribute6, lines.attribute7, lines.attribute8, lines.attribute9, lines.attribute10, lines.attribute11, lines.attribute12, lines.attribute13, lines.attribute14, lines.attribute15, lines.attribute_category, CSM_UTIL_PKG.get_debrief_header_id(header.debrief_header_id ) as debrief_header_id,CSM_UTIL_PKG.GET_NUMBER(lines.created_by) AS CREATED_BY,CSM_UTIL_PKG.GET_NUMBER(lines.last_updated_by) AS LAST_UPDATED_BY, CSM_UTIL_PKG.GET_DATE(lines.last_update_date) AS SERVER_LAST_UPDATE_DATE FROM CSM_DEBRIEF_LINES_ACC acc, CSF_DEBRIEF_LINES lines, cs_txn_billing_types txbt, CSF_DEBRIEF_HEADERS header, CS_BILLING_TYPE_CATEGORIES cbtc, mtl_system_items_b_kfv msi WHERE acc.debrief_line_id = lines.debrief_line_id and acc.user_id = asg_base.get_user_id and lines.debrief_header_id = header.debrief_header_id AND lines.transaction_type_id = txbt.transaction_type_id AND txbt.billing_type = cbtc.billing_type AND cbtc.billing_category = 'E' AND msi.inventory_item_id = lines.inventory_item_id AND msi.organization_id = NVL(csm_profile_pkg.get_service_validation_org(acc.user_id), csm_profile_pkg.get_organization_id(acc.user_id)) AND msi.material_billable_flag = txbt.billing_type

View Text - HTML Formatted

SELECT CSM_UTIL_PKG.GET_NUMBER(ACC.ACCESS_ID)
, LINES.DEBRIEF_LINE_ID
, LINES.INVENTORY_ITEM_ID
, LINES.TXN_BILLING_TYPE_ID
, CSM_UTIL_PKG.GET_NUMBER( HEADER.TASK_ASSIGNMENT_ID)
, ASG_BASE.GET_RESOURCE_ID
, LINES.QUANTITY
, LINES.EXPENSE_AMOUNT
, LINES.CURRENCY_CODE
, LINES.UOM_CODE
, LINES.BUSINESS_PROCESS_ID
, CSM_UTIL_PKG.GET_DATE(LINES.LAST_UPDATE_DATE)
, CSM_UTIL_PKG.ITEM_NAME(MSI.CONCATENATED_SEGMENTS) AS ITEM_NAME
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, LINES.TRANSACTION_TYPE_ID
, CSM_UTIL_PKG.GET_DATE(LINES.SERVICE_DATE)
, LINES.EXPENSE_REASON_CODE
, LINES.ATTRIBUTE1
, LINES.ATTRIBUTE2
, LINES.ATTRIBUTE3
, LINES.ATTRIBUTE4
, LINES.ATTRIBUTE5
, LINES.ATTRIBUTE6
, LINES.ATTRIBUTE7
, LINES.ATTRIBUTE8
, LINES.ATTRIBUTE9
, LINES.ATTRIBUTE10
, LINES.ATTRIBUTE11
, LINES.ATTRIBUTE12
, LINES.ATTRIBUTE13
, LINES.ATTRIBUTE14
, LINES.ATTRIBUTE15
, LINES.ATTRIBUTE_CATEGORY
, CSM_UTIL_PKG.GET_DEBRIEF_HEADER_ID(HEADER.DEBRIEF_HEADER_ID ) AS DEBRIEF_HEADER_ID
, CSM_UTIL_PKG.GET_NUMBER(LINES.CREATED_BY) AS CREATED_BY
, CSM_UTIL_PKG.GET_NUMBER(LINES.LAST_UPDATED_BY) AS LAST_UPDATED_BY
, CSM_UTIL_PKG.GET_DATE(LINES.LAST_UPDATE_DATE) AS SERVER_LAST_UPDATE_DATE
FROM CSM_DEBRIEF_LINES_ACC ACC
, CSF_DEBRIEF_LINES LINES
, CS_TXN_BILLING_TYPES TXBT
, CSF_DEBRIEF_HEADERS HEADER
, CS_BILLING_TYPE_CATEGORIES CBTC
, MTL_SYSTEM_ITEMS_B_KFV MSI
WHERE ACC.DEBRIEF_LINE_ID = LINES.DEBRIEF_LINE_ID
AND ACC.USER_ID = ASG_BASE.GET_USER_ID
AND LINES.DEBRIEF_HEADER_ID = HEADER.DEBRIEF_HEADER_ID
AND LINES.TRANSACTION_TYPE_ID = TXBT.TRANSACTION_TYPE_ID
AND TXBT.BILLING_TYPE = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY = 'E'
AND MSI.INVENTORY_ITEM_ID = LINES.INVENTORY_ITEM_ID
AND MSI.ORGANIZATION_ID = NVL(CSM_PROFILE_PKG.GET_SERVICE_VALIDATION_ORG(ACC.USER_ID)
, CSM_PROFILE_PKG.GET_ORGANIZATION_ID(ACC.USER_ID))
AND MSI.MATERIAL_BILLABLE_FLAG = TXBT.BILLING_TYPE