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.

APPS.FV_SF1081_TRANSACTION dependencies on RA_CUSTOMER_TRX

Line 366: vc_trx_number ra_customer_trx.trx_number%TYPE;

362: --
363: l_ledger_id number;
364: l_ledger_name varchar2(200);
365: --
366: vc_trx_number ra_customer_trx.trx_number%TYPE;
367: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
368: vc_customer_name hz_parties.party_name%TYPE;
369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;

Line 367: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;

363: l_ledger_id number;
364: l_ledger_name varchar2(200);
365: --
366: vc_trx_number ra_customer_trx.trx_number%TYPE;
367: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
368: vc_customer_name hz_parties.party_name%TYPE;
369: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
370: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
371: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;

Line 378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

374: vc_address3 hz_locations.address3%TYPE;
375: vc_city hz_locations.city%TYPE;
376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
381: vc_trx_date ra_customer_trx.trx_date%TYPE;
382: vc_code_combination_id number;

Line 380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

376: vc_state hz_locations.state%TYPE;
377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
381: vc_trx_date ra_customer_trx.trx_date%TYPE;
382: vc_code_combination_id number;
383:
384: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;

Line 381: vc_trx_date ra_customer_trx.trx_date%TYPE;

377: vc_postal_code hz_locations.postal_code%TYPE;
378: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
379: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
380: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
381: vc_trx_date ra_customer_trx.trx_date%TYPE;
382: vc_code_combination_id number;
383:
384: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
385: err number;

Line 408: RA_CUSTOMER_TRX RCT,

404: RCT.BILL_TO_CUSTOMER_ID,
405: RCT.TRX_DATE,
406: RLD.CODE_COMBINATION_ID
407: FROM
408: RA_CUSTOMER_TRX RCT,
409: RA_CUSTOMER_TRX_LINES RTL,
410: RA_CUST_TRX_LINE_GL_DIST RLD,
411: HZ_CUST_SITE_USES HZCSU,
412: HZ_LOCATIONS HZL,

Line 409: RA_CUSTOMER_TRX_LINES RTL,

405: RCT.TRX_DATE,
406: RLD.CODE_COMBINATION_ID
407: FROM
408: RA_CUSTOMER_TRX RCT,
409: RA_CUSTOMER_TRX_LINES RTL,
410: RA_CUST_TRX_LINE_GL_DIST RLD,
411: HZ_CUST_SITE_USES HZCSU,
412: HZ_LOCATIONS HZL,
413: HZ_CUST_ACCT_SITES HZCAS,

Line 504: ra_customer_trx rct,

500: hz_party_sites hzps ,
501: HZ_CUST_SITE_USEs hzcsu,
502: hz_cust_accounts hzca,
503: hz_parties hzp,
504: ra_customer_trx rct,
505: ra_customer_trx_lines rtl,
506: ra_cust_trx_line_gl_dist rld,
507: ce_bank_accounts cba,
508: ce_bank_acct_uses_all cbau

Line 505: ra_customer_trx_lines rtl,

501: HZ_CUST_SITE_USEs hzcsu,
502: hz_cust_accounts hzca,
503: hz_parties hzp,
504: ra_customer_trx rct,
505: ra_customer_trx_lines rtl,
506: ra_cust_trx_line_gl_dist rld,
507: ce_bank_accounts cba,
508: ce_bank_acct_uses_all cbau
509: WHERE

Line 563: FROM ra_customer_trx

559: FROM hz_cust_accounts hzca
560: WHERE cust_account_id LIKE NVL(parm_customer,'%')))
561: AND rct.customer_trx_id IN
562: (SELECT customer_trx_id
563: FROM ra_customer_trx
564: WHERE NVL(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
565: AND ((rct.customer_trx_id IN
566: (SELECT customer_trx_id
567: FROM ra_customer_trx

Line 567: FROM ra_customer_trx

563: FROM ra_customer_trx
564: WHERE NVL(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
565: AND ((rct.customer_trx_id IN
566: (SELECT customer_trx_id
567: FROM ra_customer_trx
568: WHERE batch_id IN
569: (SELECT batch_id
570: FROM ra_batches
571: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))

Line 575: FROM ra_customer_trx rct

571: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))
572: OR (parm_batch is null and (NVL(BATCH_ID,'99') LIKE DECODE(parm_print_choice,'SEL','99','NEW','99'))))
573: AND rct.customer_trx_id IN
574: (SELECT rct.customer_trx_id
575: FROM ra_customer_trx rct
576: WHERE (NVL(rct.printing_count,'99') LIKE
577: DECODE(parm_print_choice,'NEW','99','%'))
578: AND (NVL(TO_CHAR(rct.printing_original_date,'DD-MM-YYYY'),'01-01-1999') LIKE
579: DECODE(parm_print_choice,'NEW','01-01-1999','%'))