[Home] [Help]
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;
372: vc_address1 hz_locations.address1%TYPE;
373: vc_address2 hz_locations.address2%TYPE;
410: RA_CUST_TRX_LINE_GL_DIST RLD,
411: HZ_CUST_SITE_USES HZCSU,
412: HZ_LOCATIONS HZL,
413: HZ_CUST_ACCT_SITES HZCAS,
414: HZ_CUST_ACCOUNTS HZCA,
415: HZ_PARTY_SITES HZPS,
416: HZ_PARTIES HZP
417: WHERE
418: RCT.CUSTOMER_TRX_ID = RTL.CUSTOMER_TRX_ID
498: hz_locations hzl,
499: hz_cust_acct_sites hzcas,
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,
550: AND rct.trx_date BETWEEN DECODE(parm_print_date_low,null,TO_DATE('1990/1/1', 'yyyy/mm/dd'), parm_print_date_low)
551: AND DECODE(parm_print_date_high,null,trunc(sysdate),parm_print_date_high )
552: AND hzca.cust_account_id IN
553: ((SELECT cust_account_id
554: FROM hz_cust_accounts hzca
555: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
556: NVL(customer_class_code,'XXX'),parm_customer_class))
557: INTERSECT
558: (SELECT cust_account_id
555: WHERE NVL(customer_class_code,'XXX') LIKE DECODE(parm_customer_class,null,
556: NVL(customer_class_code,'XXX'),parm_customer_class))
557: INTERSECT
558: (SELECT cust_account_id
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