eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.DPP_TXN_DASHBOARD_V

Source

View Text - Preformatted


SELECT HAO.NAME OPERATING_UNIT, DAH.REF_DOCUMENT_NUMBER, APS.VENDOR_NAME SUPPLIER_NAME, DAH.TRANSACTION_HEADER_ID, DAH.TRANSACTION_NUMBER TRANSACTION_NUMBER, DAH.CREATION_DATE, DAH.EFFECTIVE_START_DATE, DAH.TRANSACTION_SOURCE, DAH.TRANSACTION_STATUS, DAH.FOLLOWUP_ACTION, FLV.MEANING, (SELECT FLV1.MEANING FROM FND_LOOKUP_VALUES_VL FLV1 WHERE FLV1.lookup_type='DPP_TXN_FOLLOWUP_ACTIONS' AND FLV1.lookup_code =DAH.FOLLOWUP_ACTION ) TxnFollowupAction, (SELECT SUM(CLAIM_AMOUNT) FROM DPP_TRANSACTION_LINES_ALL DAL WHERE DAH.TRANSACTION_HEADER_ID=DAL.TRANSACTION_HEADER_ID AND DAH.ORG_ID=DAL.ORG_ID) CLAIMED_AMOUNT, DAH.TRX_CURRENCY ONHAND_INV_CURRENCY, (SELECT SUM(NVL(gl_currency_api.convert_closest_amount_sql ( DCC.trx_currency, DAH.trx_currency, sysdate, fnd_profile.value('DPP_CURRENCY_CONVERSION_TYPE'), NULL, dcc.cust_claim_amt,-1),0)) FROM DPP_CUSTOMER_CLAIMS_ALL DCC WHERE DAH.TRANSACTION_HEADER_ID=DCC.TRANSACTION_HEADER_ID AND DCC.TRX_CURRENCY IS NOT NULL AND DCC.CUST_CLAIM_AMT is not null) CUST_CLAIM_AMOUNT, DAH.TRX_CURRENCY CLAIM_CURRENCY FROM AP_SUPPLIERS APS, DPP_TRANSACTION_HEADERS DAH, FND_LOOKUP_VALUES_VL FLV , HR_ALL_ORGANIZATION_UNITS HAO WHERE DAH.VENDOR_ID=APS.VENDOR_ID AND FLV.lookup_type='DPP_TRANSACTION_STATUSES' AND SYSDATE BETWEEN FLV.START_DATE_ACTIVE AND NVL(FLV.END_DATE_ACTIVE,SYSDATE) AND FLV.lookup_code=DAH.TRANSACTION_STATUS AND HAO.ORGANIZATION_ID=DAH.ORG_ID

View Text - HTML Formatted

SELECT HAO.NAME OPERATING_UNIT
, DAH.REF_DOCUMENT_NUMBER
, APS.VENDOR_NAME SUPPLIER_NAME
, DAH.TRANSACTION_HEADER_ID
, DAH.TRANSACTION_NUMBER TRANSACTION_NUMBER
, DAH.CREATION_DATE
, DAH.EFFECTIVE_START_DATE
, DAH.TRANSACTION_SOURCE
, DAH.TRANSACTION_STATUS
, DAH.FOLLOWUP_ACTION
, FLV.MEANING
, (SELECT FLV1.MEANING
FROM FND_LOOKUP_VALUES_VL FLV1
WHERE FLV1.LOOKUP_TYPE='DPP_TXN_FOLLOWUP_ACTIONS'
AND FLV1.LOOKUP_CODE =DAH.FOLLOWUP_ACTION ) TXNFOLLOWUPACTION
, (SELECT SUM(CLAIM_AMOUNT)
FROM DPP_TRANSACTION_LINES_ALL DAL
WHERE DAH.TRANSACTION_HEADER_ID=DAL.TRANSACTION_HEADER_ID
AND DAH.ORG_ID=DAL.ORG_ID) CLAIMED_AMOUNT
, DAH.TRX_CURRENCY ONHAND_INV_CURRENCY
, (SELECT SUM(NVL(GL_CURRENCY_API.CONVERT_CLOSEST_AMOUNT_SQL ( DCC.TRX_CURRENCY
, DAH.TRX_CURRENCY
, SYSDATE
, FND_PROFILE.VALUE('DPP_CURRENCY_CONVERSION_TYPE')
, NULL
, DCC.CUST_CLAIM_AMT
, -1)
, 0))
FROM DPP_CUSTOMER_CLAIMS_ALL DCC
WHERE DAH.TRANSACTION_HEADER_ID=DCC.TRANSACTION_HEADER_ID
AND DCC.TRX_CURRENCY IS NOT NULL
AND DCC.CUST_CLAIM_AMT IS NOT NULL) CUST_CLAIM_AMOUNT
, DAH.TRX_CURRENCY CLAIM_CURRENCY
FROM AP_SUPPLIERS APS
, DPP_TRANSACTION_HEADERS DAH
, FND_LOOKUP_VALUES_VL FLV
, HR_ALL_ORGANIZATION_UNITS HAO
WHERE DAH.VENDOR_ID=APS.VENDOR_ID
AND FLV.LOOKUP_TYPE='DPP_TRANSACTION_STATUSES'
AND SYSDATE BETWEEN FLV.START_DATE_ACTIVE
AND NVL(FLV.END_DATE_ACTIVE
, SYSDATE)
AND FLV.LOOKUP_CODE=DAH.TRANSACTION_STATUS
AND HAO.ORGANIZATION_ID=DAH.ORG_ID