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.AP_SLA_INVOICES_TRANSACTION_V

Source

View Text - Preformatted


SELECT
  AI.invoice_id,
  HZP.party_name,
  HZPS.party_site_name,
  AI.invoice_num,
  DECODE(AI.cancelled_date,NULL,AI.invoice_amount,AI.cancelled_amount) invoice_amount,
   /* bug:7375417*/
  ALC.DISPLAYED_FIELD PAYMENT_STATUS, /* Bug 7039815 */
  AI.base_amount,
  AI.invoice_type_lookup_code,
  AI.invoice_date,
  AI.cancelled_date,
  AI.description,
  AI.terms_date,
  (SELECT atl.due_days
   FROM   ap_terms_lines ATL
   WHERE  AI.terms_id = ATL.term_id
   AND    ROWNUM = 1
  ) due_days
from ap_invoices_all AI, hz_parties HZP , hz_party_sites HZPS,ap_suppliers AS1
    ,AP_LOOKUP_CODES   ALC               /* Bug 7039815 */
where  AI.vendor_id = AS1.vendor_id(+)       /*  Bug 7019211 ,  6150175  */
and    AI.party_id = HZP.party_id
and    AI.party_site_id = HZPS.party_site_id(+)
and    ( ( AS1.employee_id is null and HZPS.party_site_id is not null)
         OR ( AS1.employee_id is not null))
AND    ALC.LOOKUP_TYPE (+)  = 'INVOICE PAYMENT STATUS'  /* Bug 7039815 */
AND    ALC.LOOKUP_CODE (+)  = AI.PAYMENT_STATUS_FLAG    /* Bug 7039815 */

View Text - HTML Formatted

SELECT AI.INVOICE_ID
, HZP.PARTY_NAME
, HZPS.PARTY_SITE_NAME
, AI.INVOICE_NUM
, DECODE(AI.CANCELLED_DATE
, NULL
, AI.INVOICE_AMOUNT
, AI.CANCELLED_AMOUNT) INVOICE_AMOUNT
, /* BUG:7375417*/ ALC.DISPLAYED_FIELD PAYMENT_STATUS
, /* BUG 7039815 */ AI.BASE_AMOUNT
, AI.INVOICE_TYPE_LOOKUP_CODE
, AI.INVOICE_DATE
, AI.CANCELLED_DATE
, AI.DESCRIPTION
, AI.TERMS_DATE
, (SELECT ATL.DUE_DAYS
FROM AP_TERMS_LINES ATL
WHERE AI.TERMS_ID = ATL.TERM_ID
AND ROWNUM = 1 ) DUE_DAYS FROM AP_INVOICES_ALL AI
, HZ_PARTIES HZP
, HZ_PARTY_SITES HZPS
, AP_SUPPLIERS AS1
, AP_LOOKUP_CODES ALC /* BUG 7039815 */ WHERE AI.VENDOR_ID = AS1.VENDOR_ID(+) /* BUG 7019211
, 6150175 */ AND AI.PARTY_ID = HZP.PARTY_ID AND AI.PARTY_SITE_ID = HZPS.PARTY_SITE_ID(+) AND ( ( AS1.EMPLOYEE_ID IS NULL
AND HZPS.PARTY_SITE_ID IS NOT NULL) OR ( AS1.EMPLOYEE_ID IS NOT NULL)) AND ALC.LOOKUP_TYPE (+) = 'INVOICE PAYMENT STATUS' /* BUG 7039815 */ AND ALC.LOOKUP_CODE (+) = AI.PAYMENT_STATUS_FLAG /* BUG 7039815 */