APPS.ECE_AR_TRANSACTION dependencies on HZ_CUST_ACCT_SITES

Line 387: hz_cust_acct_sites rad,

383: INTO l_EDI_flag,
384: l_Print_flag
385: FROM ra_customer_trx rct,
386: ece_tp_details etd,
387: hz_cust_acct_sites rad,
388: hz_cust_site_uses rsu
389: WHERE rct.bill_to_site_use_id = rsu.site_use_id
390: AND rsu.cust_acct_site_id = rad.cust_acct_site_id
391: AND rad.tp_header_id = etd.tp_header_id

Line 404: 'RA_CUSTOMER_TRX, ECE_TP_DETAILS, HZ_CUST_ACCT_SITES,HZ_CUST_SITE_USES' );

400: xProgress,
401: 'INFO',
402: 'EDI FLAG, PRINT FLAG',
403: 'TABLE_NAME',
404: 'RA_CUSTOMER_TRX, ECE_TP_DETAILS, HZ_CUST_ACCT_SITES,HZ_CUST_SITE_USES' );
405: END;
406:
407: IF l_EDI_Flag = 'Y' AND
408: l_Print_Flag = 'Y'

Line 552: hz_cust_acct_sites a,

548:
549: CURSOR remit_cur IS
550: SELECT rt.address_id
551: FROM ra_customer_trx rct,
552: hz_cust_acct_sites a,
553: hz_party_sites hps,
554: hz_locations loc,
555: ra_remit_tos rt
556: WHERE rct.customer_trx_id = Get_Remit_Address.Customer_Trx_ID

Line 663: FROM hz_cust_acct_sites hcas,

659: Remit_To_Postal_Code,
660: Remit_To_Code_Int,
661: Remit_to_customer_name, --2291130
662: Remit_to_edi_location_code
663: FROM hz_cust_acct_sites hcas,
664: hz_party_sites hps,
665: hz_locations loc
666: WHERE hps.party_site_id = hcas.party_site_id
667: AND hps.location_id = loc.location_id

Line 680: 'HZ_CUST_ACCT_SITES' );

676: xProgress,
677: 'INFO',
678: 'RA ADDRESS',
679: 'TABLE_NAME',
680: 'HZ_CUST_ACCT_SITES' );
681: END;
682:
683: ec_debug.pop('ECE_AR_TRANSACTION.GET_REMIT_ADDRESS');
684: