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.IGIRCBAP dependencies on RA_CUST_TRX_LINE_GL_DIST

Line 189: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

185: | amounts of a given type (LINE, TAX, FREIGHT, CHARGES, INVOICE) |
186: | that are currently applied to a given payment schedule. |
187: | The information is extracted from the igi_ar_cash_basis_dists |
188: | table, and is returned ordered by source ('GL' then 'ADJ') and |
189: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
190: | PARAMETERS |
191: | p_ps_id Payment Schedule Id for which current |
192: | applications are required |
193: | p_type The type of current applications required - |

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

289: | CurrentRevDistribution |
290: | DESCRIPTION |
291: | Populates PL/SQL tables with the current 'revenue' distribution of |
292: | the given Payment Schedule for a given type. |
293: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
294: | records of account_class 'REV' and adjustments where |
295: | line_adjusted IS NOT NULL |
296: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
297: | records of account_class 'TAX' and adjustments where |

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

292: | the given Payment Schedule for a given type. |
293: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
294: | records of account_class 'REV' and adjustments where |
295: | line_adjusted IS NOT NULL |
296: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
297: | records of account_class 'TAX' and adjustments where |
298: | tax_adjusted IS NOT NULL |
299: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
300: | records of account_class 'FREIGHT' and adjustments where |

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

295: | line_adjusted IS NOT NULL |
296: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
297: | records of account_class 'TAX' and adjustments where |
298: | tax_adjusted IS NOT NULL |
299: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
300: | records of account_class 'FREIGHT' and adjustments where |
301: | freight_adjusted IS NOT NULL |
302: | For type 'CHARGES' the distributions include adjustments where |
303: | receivables_charges_adjusted IS NOT NULL |

Line 305: | ra_cust_trx_line_gl_dist records and all adjustments |

301: | freight_adjusted IS NOT NULL |
302: | For type 'CHARGES' the distributions include adjustments where |
303: | receivables_charges_adjusted IS NOT NULL |
304: | For type 'INVOICE' the distributions include all |
305: | ra_cust_trx_line_gl_dist records and all adjustments |
306: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
307: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
308: | |
309: | PARAMETERS |

Line 307: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

303: | receivables_charges_adjusted IS NOT NULL |
304: | For type 'INVOICE' the distributions include all |
305: | ra_cust_trx_line_gl_dist records and all adjustments |
306: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
307: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
308: | |
309: | PARAMETERS |
310: | p_Post RECORD type that contains posting parameters |
311: | p_ps_id payment_schedule_id for which distribution is required |

Line 363: FROM ra_cust_trx_line_gl_dist ctlgd

359: ctlgd.code_combination_id ccid,
360: substrb(decode(ctlgd.account_class,
361: 'REV','LINE',
362: ctlgd.account_class),1,15) accntclass
363: FROM ra_cust_trx_line_gl_dist ctlgd
364: WHERE ctlgd.customer_trx_id = cp_ctid
365: AND ctlgd.account_class IN ( 'REV', 'TAX', 'FREIGHT','CHARGES' ) -- we are only interested in these classes
366: AND ctlgd.account_class = DECODE
367: (

Line 2350: FROM ra_cust_trx_line_gl_dist

2346: AND igiadj.arc_posting_control_id = p_PostingControlId;
2347:
2348: SELECT nvl(max(cust_trx_line_gl_dist_id), 999999999999998)+1
2349: INTO l_Post.NxtCustTrxLineGlDistId
2350: FROM ra_cust_trx_line_gl_dist
2351: WHERE posting_control_id = p_PostingControlId;
2352:
2353: ***/
2354: l_Post.NxtCashReceiptHistoryId := 999999999999999;