eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ARP_AUTO_RULE dependencies on RA_CUST_TRX_LINE_GL_DIST_S

Line 896: ra_cust_trx_line_gl_dist_s.NEXTVAL, /* cust_trx_line_gl_dist_id */

892: sysdate,
893: arp_standard.profile.user_id,
894: -3,
895: ass.gl_date, /* original_gl_date */
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,

Line 945: ra_cust_trx_line_gl_dist subdist2

941: 0, NVL(lines.previous_customer_trx_line_id,
942: lines.customer_trx_line_id),
943: lines.customer_trx_line_id)
944: FROM
945: ra_cust_trx_line_gl_dist subdist2
946: WHERE
947: subdist2.customer_trx_line_id = lines.customer_trx_line_id
948: AND subdist2.account_set_flag = 'Y'
949: AND subdist2.gl_date IS NULL

Line 964: ra_cust_trx_line_gl_dist subdist

960: (
961: SELECT
962: 'distribution exists'
963: FROM
964: ra_cust_trx_line_gl_dist subdist
965: WHERE
966: subdist.customer_trx_line_id = ass.customer_trx_line_id
967: AND subdist.customer_trx_id + 0 = lines.customer_trx_id
968: AND subdist.account_set_flag = 'N'

Line 1108: ra_cust_trx_line_gl_dist_s.NEXTVAL,

1104: arp_standard.profile.program_id,
1105: sysdate,
1106: -3, /* posting_control_id */
1107: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1108: ra_cust_trx_line_gl_dist_s.NEXTVAL,
1109: header.org_id
1110: FROM
1111: ra_cust_trx_line_gl_dist rec,
1112: ra_customer_trx header

Line 1306: ra_cust_trx_line_gl_dist_s.nextval,

1302: arp_standard.profile.program_id,
1303: sysdate,
1304: -3, /* posting_control_id */
1305: NVL(NVL(rec.original_gl_date, rec.gl_date), header.trx_date),
1306: ra_cust_trx_line_gl_dist_s.nextval,
1307: header.org_id
1308: FROM
1309: ra_customer_trx header,
1310: ra_cust_trx_line_gl_dist rec, /* ROUND row */

Line 1588: ra_cust_trx_line_gl_dist_s.NEXTVAL,

1584: arp_standard.profile.program_id,
1585: sysdate,
1586: -3, /* posting_control_id */
1587: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
1588: ra_cust_trx_line_gl_dist_s.NEXTVAL,
1589: /* Bug 2150541 */
1590: DECODE(psum.account_class, 'UNEARN', 'Y',
1591: 'UNBILL', 'Y',
1592: NULL) ,

Line 1632: ra_cust_trx_line_gl_dist subdist2

1628: 0, NVL(lines.previous_customer_trx_line_id,
1629: lines.customer_trx_line_id),
1630: lines.customer_trx_line_id)
1631: FROM
1632: ra_cust_trx_line_gl_dist subdist2
1633: WHERE
1634: subdist2.customer_trx_line_id = lines.customer_trx_line_id
1635: AND subdist2.account_set_flag = 'Y'
1636: AND subdist2.gl_date IS NULL

Line 1656: ra_cust_trx_line_gl_dist subdist

1652: (
1653: SELECT
1654: 'plug sum account exists'
1655: FROM
1656: ra_cust_trx_line_gl_dist subdist
1657: WHERE
1658: subdist.account_class IN
1659: ( 'SUSPENSE', DECODE(trx.invoicing_rule_id,
1660: -2, 'UNEARN',

Line 1791: ra_cust_trx_line_gl_dist_s.NEXTVAL,

1787: arp_standard.profile.program_id,
1788: sysdate,
1789: -3, /* posting_control_id */
1790: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
1791: ra_cust_trx_line_gl_dist_s.NEXTVAL,
1792: /* Bug 2150541 */
1793: DECODE(psum.account_class, 'UNEARN', 'Y',
1794: 'UNBILL', 'Y',
1795: NULL),

Line 1844: ra_cust_trx_line_gl_dist subdist

1840: (
1841: SELECT
1842: 'plug sum account exists'
1843: FROM
1844: ra_cust_trx_line_gl_dist subdist
1845: WHERE
1846: subdist.account_class IN
1847: ( 'SUSPENSE', DECODE(trx.invoicing_rule_id,
1848: -2, 'UNEARN',

Line 2049: ra_cust_trx_line_gl_dist_s.NEXTVAL,

2045: arp_standard.profile.program_id,
2046: sysdate,
2047: -3,
2048: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2049: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2050: tax.collected_tax_ccid,
2051: trx.org_id
2052: FROM
2053: ra_customer_trx model_trx,

Line 2083: ra_cust_trx_line_gl_dist subdist2

2079: 0, NVL(tax_line.previous_customer_trx_line_id,
2080: tax_line.customer_trx_line_id),
2081: tax_line.customer_trx_line_id)
2082: FROM
2083: ra_cust_trx_line_gl_dist subdist2
2084: WHERE
2085: subdist2.customer_trx_line_id=tax_line.customer_trx_line_id
2086: AND subdist2.account_set_flag = 'Y'
2087: AND subdist2.gl_date IS NULL

Line 2098: ra_cust_trx_line_gl_dist subdist

2094: AND NOT EXISTS
2095: (SELECT
2096: 'tax account exists'
2097: FROM
2098: ra_cust_trx_line_gl_dist subdist
2099: WHERE
2100: tax_line.customer_trx_line_id = subdist.customer_trx_line_id
2101: AND subdist.account_set_flag = 'N'
2102: AND subdist.gl_date IS NOT NULL

Line 2248: ra_cust_trx_line_gl_dist_s.NEXTVAL,

2244: arp_standard.profile.program_id,
2245: sysdate,
2246: -3,
2247: NVL( NVL(rec.original_gl_date, rec.gl_date), trx.trx_date),
2248: ra_cust_trx_line_gl_dist_s.NEXTVAL,
2249: trx.org_id
2250: FROM
2251: ra_customer_trx model_trx,
2252: ra_cust_trx_line_gl_dist freight,

Line 2284: ra_cust_trx_line_gl_dist subdist2

2280: 0, NVL(lines.previous_customer_trx_line_id,
2281: lines.customer_trx_line_id),
2282: lines.customer_trx_line_id)
2283: FROM
2284: ra_cust_trx_line_gl_dist subdist2
2285: WHERE
2286: subdist2.customer_trx_line_id = lines.customer_trx_line_id
2287: AND subdist2.account_set_flag = 'Y'
2288: AND subdist2.gl_date IS NULL

Line 2300: ra_cust_trx_line_gl_dist subdist

2296: AND NOT EXISTS
2297: (SELECT
2298: 'freight account exists'
2299: FROM
2300: ra_cust_trx_line_gl_dist subdist
2301: WHERE
2302: subdist.customer_trx_line_id = lines.customer_trx_line_id
2303: AND subdist.account_set_flag = 'N'
2304: AND subdist.gl_date IS NOT NULL