VIEW: APPS.CSF_M_DEBRIEF_LABOR_V

Source

View Text - Preformatted

SELECT acc.access_id , lines.debrief_line_id , lines.inventory_item_id , lines.txn_billing_type_id , header.task_assignment_id , asg_base.get_resource_id as RESOURCE_ID, lines.labor_start_date , lines.labor_end_date , lines.business_process_id, lines.last_update_date, lines.quantity, lines.uom_code, lines.service_date, csm_util_pkg.item_name(msi.concatenated_segments) AS item_name, msi.description AS item_description, lines.transaction_type_id, lines.labor_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, lines.last_update_date AS SERVER_LAST_UPDATE_DATE from CSM_DEBRIEF_LINES_ACC acc , CSF_DEBRIEF_LINES lines , cs_txn_billing_types txbt, CS_BILLING_TYPE_CATEGORIES cbtc, CSF_DEBRIEF_HEADERS header, 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 = 'L' 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 UNION SELECT acc.access_id , lines.debrief_line_id , lines.inventory_item_id , lines.txn_billing_type_id , header.task_assignment_id , asg_base.get_resource_id as RESOURCE_ID, lines.labor_start_date , lines.labor_end_date , lines.business_process_id, lines.last_update_date, lines.quantity, lines.uom_code, lines.service_date, NULL AS item_name, NULL AS item_description, lines.transaction_type_id, lines.labor_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, header.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, lines.last_update_date AS SERVER_LAST_UPDATE_DATE FROM CSM_DEBRIEF_LINES_ACC acc , CSF_DEBRIEF_LINES lines , cs_txn_billing_types txbt, CS_BILLING_TYPE_CATEGORIES cbtc, CSF_DEBRIEF_HEADERS header 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 lines.inventory_item_id IS null AND txbt.billing_type = cbtc.billing_type AND cbtc.billing_category = 'L'

View Text - HTML Formatted

SELECT ACC.ACCESS_ID
, LINES.DEBRIEF_LINE_ID
, LINES.INVENTORY_ITEM_ID
, LINES.TXN_BILLING_TYPE_ID
, HEADER.TASK_ASSIGNMENT_ID
, ASG_BASE.GET_RESOURCE_ID AS RESOURCE_ID
, LINES.LABOR_START_DATE
, LINES.LABOR_END_DATE
, LINES.BUSINESS_PROCESS_ID
, LINES.LAST_UPDATE_DATE
, LINES.QUANTITY
, LINES.UOM_CODE
, LINES.SERVICE_DATE
, CSM_UTIL_PKG.ITEM_NAME(MSI.CONCATENATED_SEGMENTS) AS ITEM_NAME
, MSI.DESCRIPTION AS ITEM_DESCRIPTION
, LINES.TRANSACTION_TYPE_ID
, LINES.LABOR_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
, LINES.LAST_UPDATE_DATE AS SERVER_LAST_UPDATE_DATE
FROM CSM_DEBRIEF_LINES_ACC ACC
, CSF_DEBRIEF_LINES LINES
, CS_TXN_BILLING_TYPES TXBT
, CS_BILLING_TYPE_CATEGORIES CBTC
, CSF_DEBRIEF_HEADERS HEADER
, 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 = 'L'
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 UNION SELECT ACC.ACCESS_ID
, LINES.DEBRIEF_LINE_ID
, LINES.INVENTORY_ITEM_ID
, LINES.TXN_BILLING_TYPE_ID
, HEADER.TASK_ASSIGNMENT_ID
, ASG_BASE.GET_RESOURCE_ID AS RESOURCE_ID
, LINES.LABOR_START_DATE
, LINES.LABOR_END_DATE
, LINES.BUSINESS_PROCESS_ID
, LINES.LAST_UPDATE_DATE
, LINES.QUANTITY
, LINES.UOM_CODE
, LINES.SERVICE_DATE
, NULL AS ITEM_NAME
, NULL AS ITEM_DESCRIPTION
, LINES.TRANSACTION_TYPE_ID
, LINES.LABOR_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
, HEADER.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
, LINES.LAST_UPDATE_DATE AS SERVER_LAST_UPDATE_DATE
FROM CSM_DEBRIEF_LINES_ACC ACC
, CSF_DEBRIEF_LINES LINES
, CS_TXN_BILLING_TYPES TXBT
, CS_BILLING_TYPE_CATEGORIES CBTC
, CSF_DEBRIEF_HEADERS HEADER
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 LINES.INVENTORY_ITEM_ID IS NULL
AND TXBT.BILLING_TYPE = CBTC.BILLING_TYPE
AND CBTC.BILLING_CATEGORY = 'L'