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

Line 231: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

227: | amounts of a given type (LINE, TAX, FREIGHT, CHARGES, INVOICE) |
228: | that are currently applied to a given payment schedule. |
229: | The information is extracted from the ar_cash_basis_distributions |
230: | table, and is returned ordered by source ('GL' then 'ADJ') and |
231: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
232: | PARAMETERS |
233: | p_Post RECORD type that contains posting parameters
234: | p_ps_id Payment Schedule Id for which current |
235: | applications are required |

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

378: | CurrentRevDistribution |
379: | DESCRIPTION |
380: | Populates PL/SQL tables with the current 'revenue' distribution of |
381: | the given Payment Schedule for a given type. |
382: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
383: | records of account_class 'REV' and adjustments where |
384: | line_adjusted IS NOT NULL |
385: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
386: | records of account_class 'TAX' and adjustments where |

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

381: | the given Payment Schedule for a given type. |
382: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
383: | records of account_class 'REV' and adjustments where |
384: | line_adjusted IS NOT NULL |
385: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
386: | records of account_class 'TAX' and adjustments where |
387: | tax_adjusted IS NOT NULL |
388: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
389: | records of account_class 'FREIGHT' and adjustments where |

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

384: | line_adjusted IS NOT NULL |
385: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
386: | records of account_class 'TAX' and adjustments where |
387: | tax_adjusted IS NOT NULL |
388: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
389: | records of account_class 'FREIGHT' and adjustments where |
390: | freight_adjusted IS NOT NULL |
391: | For type 'CHARGES' the distributions include adjustments where |
392: | receivables_charges_adjusted IS NOT NULL |

Line 394: | ra_cust_trx_line_gl_dist records and all adjustments |

390: | freight_adjusted IS NOT NULL |
391: | For type 'CHARGES' the distributions include adjustments where |
392: | receivables_charges_adjusted IS NOT NULL |
393: | For type 'INVOICE' the distributions include all |
394: | ra_cust_trx_line_gl_dist records and all adjustments |
395: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
396: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
397: | |
398: | PARAMETERS |

Line 396: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

392: | receivables_charges_adjusted IS NOT NULL |
393: | For type 'INVOICE' the distributions include all |
394: | ra_cust_trx_line_gl_dist records and all adjustments |
395: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
396: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
397: | |
398: | PARAMETERS |
399: | p_Post RECORD type that contains posting parameters |
400: | p_ps_id payment_schedule_id for which distribution is required |

Line 452: FROM ra_cust_trx_line_gl_dist ctlgd

448: ctlgd.code_combination_id ccid,
449: substrb(decode(ctlgd.account_class,
450: 'REV','LINE',
451: ctlgd.account_class),1,15) accntclass
452: FROM ra_cust_trx_line_gl_dist ctlgd
453: WHERE ctlgd.customer_trx_id = cp_ctid
454: AND ctlgd.account_class
455: IN ( 'REV', 'TAX', 'FREIGHT','CHARGES')
456: AND ctlgd.account_class = DECODE