DBA Data[Home] [Help]

APPS.FV_RECEIVABLES_ACTIVITY_PKG dependencies on RA_CUST_TRX_LINE_GL_DIST_ALL

Line 252: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,

248: interface_header_attribute3 created_from,
249: hzp1.category_code customer_category_code
250: --fvis.status
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,

Line 313: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,

309: --and aps2.customer_trx_id = fvis.customer_trx_id (+)
310: and rct2.related_customer_trx_id in
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,

Line 1014: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd,

1010: aps.payment_schedule_id,
1011: rct.interface_header_attribute3 created_from,
1012: hzp1.category_code customer_category_code
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,

Line 1069: RA_CUST_TRX_LINE_GL_DIST_ALL rctlgd3,

1065:
1066: IN
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,