[Home] [Help]
1124: FROM
1125: ar_lookups l,
1126: ra_customer_trx ct,
1127: ra_cust_trx_line_gl_dist ctlgd,
1128: ra_cust_trx_types ctt,
1129: hz_cust_accounts hca,
1130: psa_lookup_codes l1,
1131: psa_mf_trx_dist_all psa_trx_dist
1132: WHERE
1604: AND source_id = p_receivable_application_id
1605: AND rownum = 1) ard,
1606: ra_customer_trx ctcm,
1607: ra_customer_trx ctinv,
1608: ra_cust_trx_types ctt,
1609: ar_cash_receipt_history crh,
1610: psa_mf_rct_dist_all psa_rct_dist,
1611: psa_mf_trx_dist_all psa_trx_dist,
1612: psa_lookup_codes l1
1695: ra_customer_trx ctcm,
1696: ra_cust_trx_line_gl_dist gld,
1697: ra_cust_trx_line_gl_dist gld_inv,
1698: ra_customer_trx ctinv,
1699: ra_cust_trx_types ctt,
1700: ar_cash_receipt_history crh,
1701: psa_mf_rct_dist_all psa_rct_dist,
1702: psa_mf_trx_dist_all psa_trx_dist,
1703: psa_lookup_codes l1
1813: WHERE source_table = 'RA'
1814: AND source_id = p_receivable_application_id
1815: AND rownum = 1) ard,
1816: ra_customer_trx ctinv,
1817: ra_cust_trx_types ctt,
1818: ar_cash_receipt_history crhnew,
1819: ar_cash_receipt_history crhold,
1820: psa_mf_rct_dist_all psa_rct_dist,
1821: psa_mf_trx_dist_all psa_trx_dist,
2556: psa_mf_adj_dist_all psa_adj_dist,
2557: psa_mf_trx_dist_all psa_trx_dist,
2558: ra_customer_trx ct,
2559: ra_cust_trx_line_gl_dist ctlgd,
2560: ra_cust_trx_types ctt,
2561: psa_lookup_codes l
2562: WHERE psa_adj_dist.adjustment_id = adj.adjustment_id
2563: AND adj.adjustment_id = p_adjustment_id
2564: AND psa_trx_dist.cust_trx_line_gl_dist_id = psa_adj_dist.cust_trx_line_gl_dist_id
3871: ar_receivable_applications ra,
3872: ar_cash_receipts cr,
3873: ra_customer_trx ctcm,
3874: ra_customer_trx ctinv,
3875: ra_cust_trx_types ctt,
3876: ar_cash_receipt_history crh,
3877: psa_mf_rct_dist_all psa_rct_dist,
3878: psa_mf_trx_dist_all psa_trx_dist,
3879: ra_cust_trx_line_gl_dist ar_trx_dist,