APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on HZ_CUST_ACCOUNTS

Line 255: hz_cust_accounts hzca1,

251: FROM RA_CUSTOMER_TRX_ALL rct,
252: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
253: AR_PAYMENT_SCHEDULES_ALL aps,
254: --RA_CUSTOMERS rc, Bug#4476059 Quick Change
255: hz_cust_accounts hzca1,
256: hz_parties hzp1,
257: FV_RECEIVABLE_TYPES_ALL frt,
258: FV_REC_CUST_TRX_TYPES_ALL fctt,
259: GL_CODE_COMBINATIONS glc

Line 299: hz_cust_accounts hzca2,

295: -- fvis.status
296: FROM RA_CUSTOMER_TRX_ALL rct2,
297: AR_PAYMENT_SCHEDULES_ALL aps2,
298: --RA_CUSTOMERS rc2 Bug#4476059 Quick Change
299: hz_cust_accounts hzca2,
300: hz_parties hzp2
301: -- FV_INVOICE_STATUSES_ALL fvis
302: where aps2.class in ('DM','CM')
303: and hzca2.cust_account_id = rct2.bill_to_customer_id

Line 315: hz_cust_accounts hzca3,

311: (Select rct3.customer_trx_id
312: from RA_CUSTOMER_TRX_ALL rct3,
313: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
314: --RA_CUSTOMERS rc3,-- Bug#4476059 Quick Change
315: hz_cust_accounts hzca3,
316: hz_parties hzp3,
317: AR_PAYMENT_SCHEDULES_ALL aps3,
318: FV_RECEIVABLE_TYPES_ALL frt3,
319: FV_REC_CUST_TRX_TYPES_ALL fctt3,

Line 1017: hz_cust_accounts hzca1,

1013: FROM RA_CUSTOMER_TRX_ALL rct,
1014: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,
1015: AR_PAYMENT_SCHEDULES_ALL aps,
1016: --RA_CUSTOMERS rc, --Bug#4476059 Quick Change
1017: hz_cust_accounts hzca1,
1018: hz_parties hzp1,
1019: FV_RECEIVABLE_TYPES_ALL frt,
1020: FV_REC_CUST_TRX_TYPES_ALL fctt,
1021: -- FV_FUND_PARAMETERS fp, -- Bug 4655467

Line 1056: hz_cust_accounts hzca2,

1052: hzp2.category_code customer_category_code
1053: from RA_CUSTOMER_TRX_ALL rct2,
1054: ar_payment_schedules_all aps2,
1055: --ra_customers rc2 --Bug#4476059 Quick Change
1056: hz_cust_accounts hzca2,
1057: hz_parties hzp2
1058: where aps2.class in ('DM','CM')
1059: and hzca2.cust_account_id = rct2.bill_to_customer_id
1060: AND hzca2.party_id = hzp2.party_id

Line 1071: hz_cust_accounts hzca3,

1067: (Select rct3.customer_trx_id
1068: from RA_CUSTOMER_TRX_ALL rct3,
1069: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,
1070: --RA_CUSTOMERS rc3, --Bug#4476059 Quick Change
1071: hz_cust_accounts hzca3,
1072: hz_parties hzp3,
1073: AR_PAYMENT_SCHEDULES_ALL aps3,
1074: FV_RECEIVABLE_TYPES_ALL frt3,
1075: FV_REC_CUST_TRX_TYPES_ALL fctt3,

Line 1119: hz_cust_accounts hzca1,

1115: rctt.type trx_type
1116: FROM ar_adjustments_all ara,
1117: ra_customer_trx_all rct,
1118: --ra_customers rc, --Bug#4476059 Quick Change
1119: hz_cust_accounts hzca1,
1120: hz_parties hzp1,
1121: ra_cust_trx_types_all rctt,
1122: fv_system_parameters fvs
1123: WHERE rct.customer_trx_id = ara.customer_trx_id

Line 1150: hz_cust_accounts hzca1,

1146: acr.amount
1147: from ar_receivable_applications_all ara,
1148: ar_cash_receipts_all acr,
1149: --ra_customers rc, ----Bug#4476059 Quick Change
1150: hz_cust_accounts hzca1,
1151: hz_parties hzp1,
1152: ra_customer_trx_all rct
1153: where ara.cash_receipt_id = acr.cash_receipt_id
1154: and ara.status = 'APP'