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_CASH_BASIS_JE_REPORT dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 136: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

132: | amounts of a given type (LINE, TAX, FREIGHT, CHARGES, INVOICE) |
133: | that are currently applied to a given payment schedule. |
134: | The information is extracted from the ar_cash_basis_distributions |
135: | table, and is returned ordered by source ('GL' then 'ADJ') and |
136: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
137: | PARAMETERS |
138: | p_ps_id Payment Schedule Id for which current |
139: | applications are required |
140: | p_type The type of current applications required - |

Line 243: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |

239: | CurrentRevDistribution |
240: | DESCRIPTION |
241: | Populates PL/SQL tables with the current 'revenue' distribution of |
242: | the given Payment Schedule for a given type. |
243: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
244: | records of account_class 'REV' and adjustments where |
245: | line_adjusted IS NOT NULL |
246: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
247: | records of account_class 'TAX' and adjustments where |

Line 246: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |

242: | the given Payment Schedule for a given type. |
243: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
244: | records of account_class 'REV' and adjustments where |
245: | line_adjusted IS NOT NULL |
246: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
247: | records of account_class 'TAX' and adjustments where |
248: | tax_adjusted IS NOT NULL |
249: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
250: | records of account_class 'FREIGHT' and adjustments where |

Line 249: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|

245: | line_adjusted IS NOT NULL |
246: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
247: | records of account_class 'TAX' and adjustments where |
248: | tax_adjusted IS NOT NULL |
249: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
250: | records of account_class 'FREIGHT' and adjustments where |
251: | freight_adjusted IS NOT NULL |
252: | For type 'CHARGES' the distributions include adjustments where |
253: | receivables_charges_adjusted IS NOT NULL |

Line 255: | ra_cust_trx_line_gl_dist records and all adjustments |

251: | freight_adjusted IS NOT NULL |
252: | For type 'CHARGES' the distributions include adjustments where |
253: | receivables_charges_adjusted IS NOT NULL |
254: | For type 'INVOICE' the distributions include all |
255: | ra_cust_trx_line_gl_dist records and all adjustments |
256: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
257: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
258: | |
259: | PARAMETERS |

Line 257: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

253: | receivables_charges_adjusted IS NOT NULL |
254: | For type 'INVOICE' the distributions include all |
255: | ra_cust_trx_line_gl_dist records and all adjustments |
256: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
257: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
258: | |
259: | PARAMETERS |
260: | p_Report RECORD type that contains posting parameters |
261: | p_ps_id payment_schedule_id for which distribution is required |

Line 313: FROM ra_cust_trx_line_gl_dist ctlgd

309: ctlgd.code_combination_id ccid,
310: substrb(decode(ctlgd.account_class,
311: 'REV','LINE',
312: ctlgd.account_class),1,15) accntclass
313: FROM ra_cust_trx_line_gl_dist ctlgd
314: WHERE ctlgd.customer_trx_id = cp_ctid
315: AND ctlgd.account_class IN ( 'REV', 'TAX', 'FREIGHT','CHARGES' ) -- we are only interested in these classes
316: AND ctlgd.account_class = DECODE
317: (