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 408: vc_trx_number ra_customer_trx.trx_number%TYPE;

404: --
405: l_ledger_id number;
406: l_ledger_name varchar2(200);
407: --
408: vc_trx_number ra_customer_trx.trx_number%TYPE;
409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
410: vc_customer_name hz_parties.party_name%TYPE;
411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;

Line 409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;

405: l_ledger_id number;
406: l_ledger_name varchar2(200);
407: --
408: vc_trx_number ra_customer_trx.trx_number%TYPE;
409: vc_receipt_method_id ra_customer_trx.receipt_method_id%TYPE;
410: vc_customer_name hz_parties.party_name%TYPE;
411: vc_customer_id hz_cust_accounts.cust_Account_id%TYPE;
412: vc_cust_alc ce_bank_accounts.agency_location_code%TYPE;
413: vc_address_id hz_cust_acct_sites.cust_acct_site_id%type;

Line 420: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;

416: vc_address3 hz_locations.address3%TYPE;
417: vc_city hz_locations.city%TYPE;
418: vc_state hz_locations.state%TYPE;
419: vc_postal_code hz_locations.postal_code%TYPE;
420: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
421: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
422: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
423: vc_trx_date ra_customer_trx.trx_date%TYPE;
424: vc_code_combination_id number;

Line 422: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;

418: vc_state hz_locations.state%TYPE;
419: vc_postal_code hz_locations.postal_code%TYPE;
420: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
421: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
422: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
423: vc_trx_date ra_customer_trx.trx_date%TYPE;
424: vc_code_combination_id number;
425:
426: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;

Line 423: vc_trx_date ra_customer_trx.trx_date%TYPE;

419: vc_postal_code hz_locations.postal_code%TYPE;
420: vc_customer_trx_id ra_customer_trx.customer_trx_id%TYPE;
421: vc_amount ra_cust_trx_line_gl_dist.amount%TYPE;
422: vc_bill_to_customer_id ra_customer_trx.bill_to_customer_id%TYPE;
423: vc_trx_date ra_customer_trx.trx_date%TYPE;
424: vc_code_combination_id number;
425:
426: v_treasury_symbol fv_treasury_symbols.treasury_symbol%TYPE;
427: err number;

Line 450: RA_CUSTOMER_TRX RCT,

446: RCT.BILL_TO_CUSTOMER_ID,
447: RCT.TRX_DATE,
448: RLD.CODE_COMBINATION_ID
449: FROM
450: RA_CUSTOMER_TRX RCT,
451: RA_CUSTOMER_TRX_LINES RTL,
452: RA_CUST_TRX_LINE_GL_DIST RLD,
453: HZ_CUST_SITE_USES HZCSU,
454: HZ_LOCATIONS HZL,

Line 451: RA_CUSTOMER_TRX_LINES RTL,

447: RCT.TRX_DATE,
448: RLD.CODE_COMBINATION_ID
449: FROM
450: RA_CUSTOMER_TRX RCT,
451: RA_CUSTOMER_TRX_LINES RTL,
452: RA_CUST_TRX_LINE_GL_DIST RLD,
453: HZ_CUST_SITE_USES HZCSU,
454: HZ_LOCATIONS HZL,
455: HZ_CUST_ACCT_SITES HZCAS,

Line 554: ra_customer_trx rct,

550: hz_party_sites hzps ,
551: HZ_CUST_SITE_USEs hzcsu,
552: hz_cust_accounts hzca,
553: hz_parties hzp,
554: ra_customer_trx rct,
555: ra_customer_trx_lines rtl,
556: ra_cust_trx_line_gl_dist rld,
557: ce_bank_accounts cba,
558: ce_bank_acct_uses_all cbau

Line 555: ra_customer_trx_lines rtl,

551: HZ_CUST_SITE_USEs hzcsu,
552: hz_cust_accounts hzca,
553: hz_parties hzp,
554: ra_customer_trx rct,
555: ra_customer_trx_lines rtl,
556: ra_cust_trx_line_gl_dist rld,
557: ce_bank_accounts cba,
558: ce_bank_acct_uses_all cbau
559: WHERE

Line 613: FROM ra_customer_trx

609: FROM hz_cust_accounts hzca
610: WHERE cust_account_id LIKE NVL(parm_customer,'%')))
611: AND rct.customer_trx_id IN
612: (SELECT customer_trx_id
613: FROM ra_customer_trx
614: WHERE NVL(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
615: AND ((rct.customer_trx_id IN
616: (SELECT customer_trx_id
617: FROM ra_customer_trx

Line 617: FROM ra_customer_trx

613: FROM ra_customer_trx
614: WHERE NVL(status_trx,'-1') LIKE decode(parm_open_invoices_only,'Y','OP','N','%'))
615: AND ((rct.customer_trx_id IN
616: (SELECT customer_trx_id
617: FROM ra_customer_trx
618: WHERE batch_id IN
619: (SELECT batch_id
620: FROM ra_batches
621: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))

Line 625: FROM ra_customer_trx rct

621: WHERE batch_id = DECODE(parm_batch,null,BATCH_ID,parm_batch))))
622: OR (parm_batch is null and (NVL(BATCH_ID,'99') LIKE DECODE(parm_print_choice,'SEL','99','NEW','99'))))
623: AND rct.customer_trx_id IN
624: (SELECT rct.customer_trx_id
625: FROM ra_customer_trx rct
626: WHERE (NVL(rct.printing_count,'99') LIKE
627: DECODE(parm_print_choice,'NEW','99','%'))
628: AND (NVL(TO_CHAR(rct.printing_original_date,'DD-MM-YYYY'),'01-01-1999') LIKE
629: DECODE(parm_print_choice,'NEW','01-01-1999','%'))