VIEW: APPS.QPR_SR_QUOTE_COST_V

Source

View Text - Preformatted

SELECT l.quote_header_id, l.quote_line_id, nvl( (SELECT application_id FROM fnd_application_vl WHERE application_short_name = 'ASO' AND rownum < 2), qpr_sr_util.get_null_pk), 'COST', 'COST', (select meaning from qpr_lookups where lookup_type = 'QPR_DEAL_EROSIONS' and lookup_code = 'COST' and rownum < 2), qpr_sr_util.convert_global_amt(sob.currency_code, h.creation_date, 'Y', nvl(l.currency_code, h.currency_code)) * nvl( cst_cost_api.get_item_cost(1, l.inventory_item_id, l.organization_id), 0) / qpr_sr_util.uom_conv(qpr_sr_util.get_base_uom(l.inventory_item_id), l.inventory_item_id, l.uom_code) unit_cost, qpr_sr_util.convert_global_amt(sob.currency_code, h.creation_date, 'Y', nvl(l.currency_code, h.currency_code)) * nvl(cst_cost_api.get_item_cost(1, l.inventory_item_id, l.organization_id), 0) * l.quantity total_erosion from aso_quote_headers_all h, aso_quote_lines_all l, (SELECT gsob.currency_code, hoi2.organization_id FROM hr_organization_information hoi2, gl_sets_of_books gsob where hoi2.org_information_context = 'Accounting Information' AND hoi2.org_information1 = gsob.set_of_books_id) sob WHERE l.quote_header_id = h.quote_header_id AND sob.organization_id = l.organization_id AND ((nvl(fnd_profile.value('QPR_INTERNAL_CUST'), 'N') = 'N' and h.cust_account_id not in ( select cust_account_id from hz_cust_accounts where nvl(customer_type, 'C') = 'I')) or nvl(fnd_profile.value('QPR_INTERNAL_CUST'), 'N') = 'Y') AND qpr_sr_util.convert_global_amt(sob.currency_code, l.creation_date, 'Y', nvl(l.currency_code, h.currency_code)) > 0 AND qpr_sr_util.uom_conv(qpr_sr_util.get_base_uom(l.inventory_item_id), l.inventory_item_id, l.uom_code) > 0

View Text - HTML Formatted

SELECT L.QUOTE_HEADER_ID
, L.QUOTE_LINE_ID
, NVL( (SELECT APPLICATION_ID
FROM FND_APPLICATION_VL
WHERE APPLICATION_SHORT_NAME = 'ASO'
AND ROWNUM < 2)
, QPR_SR_UTIL.GET_NULL_PK)
, 'COST'
, 'COST'
, (SELECT MEANING
FROM QPR_LOOKUPS
WHERE LOOKUP_TYPE = 'QPR_DEAL_EROSIONS'
AND LOOKUP_CODE = 'COST'
AND ROWNUM < 2)
, QPR_SR_UTIL.CONVERT_GLOBAL_AMT(SOB.CURRENCY_CODE
, H.CREATION_DATE
, 'Y'
, NVL(L.CURRENCY_CODE
, H.CURRENCY_CODE)) * NVL( CST_COST_API.GET_ITEM_COST(1
, L.INVENTORY_ITEM_ID
, L.ORGANIZATION_ID)
, 0) / QPR_SR_UTIL.UOM_CONV(QPR_SR_UTIL.GET_BASE_UOM(L.INVENTORY_ITEM_ID)
, L.INVENTORY_ITEM_ID
, L.UOM_CODE) UNIT_COST
, QPR_SR_UTIL.CONVERT_GLOBAL_AMT(SOB.CURRENCY_CODE
, H.CREATION_DATE
, 'Y'
, NVL(L.CURRENCY_CODE
, H.CURRENCY_CODE)) * NVL(CST_COST_API.GET_ITEM_COST(1
, L.INVENTORY_ITEM_ID
, L.ORGANIZATION_ID)
, 0) * L.QUANTITY TOTAL_EROSION
FROM ASO_QUOTE_HEADERS_ALL H
, ASO_QUOTE_LINES_ALL L
, (SELECT GSOB.CURRENCY_CODE
, HOI2.ORGANIZATION_ID
FROM HR_ORGANIZATION_INFORMATION HOI2
, GL_SETS_OF_BOOKS GSOB
WHERE HOI2.ORG_INFORMATION_CONTEXT = 'ACCOUNTING INFORMATION'
AND HOI2.ORG_INFORMATION1 = GSOB.SET_OF_BOOKS_ID) SOB
WHERE L.QUOTE_HEADER_ID = H.QUOTE_HEADER_ID
AND SOB.ORGANIZATION_ID = L.ORGANIZATION_ID
AND ((NVL(FND_PROFILE.VALUE('QPR_INTERNAL_CUST')
, 'N') = 'N'
AND H.CUST_ACCOUNT_ID NOT IN ( SELECT CUST_ACCOUNT_ID
FROM HZ_CUST_ACCOUNTS
WHERE NVL(CUSTOMER_TYPE
, 'C') = 'I')) OR NVL(FND_PROFILE.VALUE('QPR_INTERNAL_CUST')
, 'N') = 'Y')
AND QPR_SR_UTIL.CONVERT_GLOBAL_AMT(SOB.CURRENCY_CODE
, L.CREATION_DATE
, 'Y'
, NVL(L.CURRENCY_CODE
, H.CURRENCY_CODE)) > 0
AND QPR_SR_UTIL.UOM_CONV(QPR_SR_UTIL.GET_BASE_UOM(L.INVENTORY_ITEM_ID)
, L.INVENTORY_ITEM_ID
, L.UOM_CODE) > 0