[Home] [Help]
896: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */
897: header.org_id
898: FROM
899: ra_customer_trx header,
900: fnd_currencies fc,
901: ra_customer_trx_lines lines,
902: ra_rules acc_rule,
903: ra_cust_trx_line_gl_dist rec,
904: ra_cust_trx_line_gl_dist dist,
1597: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1598: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1599: ra_customer_trx_lines lines,
1600: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1601: fnd_currencies fc,
1602: ra_customer_trx trx
1603: WHERE
1604: trx.customer_trx_id = p_trx_id
1605: AND trx.complete_flag = 'Y'
1800: ra_cust_trx_line_gl_dist psum, /* model plug account assignments */
1801: ra_cust_trx_line_salesreps cmsrep, /* 2899714 */
1802: ra_customer_trx_lines lines,
1803: ra_cust_trx_line_gl_dist rec, /* model receivable account */
1804: fnd_currencies fc,
1805: ra_customer_trx trx
1806: WHERE
1807: trx.customer_trx_id = p_trx_id
1808: AND trx.complete_flag = 'Y'
2054: ra_cust_trx_line_gl_dist tax,
2055: ra_customer_trx_lines tax_line,
2056: ra_customer_trx_lines line_line,
2057: ra_cust_trx_line_gl_dist rec,
2058: fnd_currencies fc,
2059: ra_customer_trx trx
2060: WHERE
2061: trx.customer_trx_id = p_trx_id
2062: AND trx.complete_flag = 'Y'
2251: ra_customer_trx model_trx,
2252: ra_cust_trx_line_gl_dist freight,
2253: ra_customer_trx_lines lines,
2254: ra_cust_trx_line_gl_dist rec,
2255: fnd_currencies fc,
2256: ra_customer_trx trx
2257: WHERE
2258: trx.customer_trx_id = p_trx_id
2259: AND trx.complete_flag = 'Y'
2738: period_set_name,
2739: base_precision,
2740: base_min_acc_unit
2741: FROM
2742: fnd_currencies fc,
2743: gl_sets_of_books gsb,
2744: ar_system_parameters asp
2745: WHERE
2746: gsb.set_of_books_id = asp.set_of_books_id