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

Line 153: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

149: | amounts of a given type (LINE, TAX, FREIGHT, CHARGES, INVOICE) |
150: | that are currently applied to a given payment schedule. |
151: | The information is extracted from the igi_ar_cash_basis_dists |
152: | table, and is returned ordered by source ('GL' then 'ADJ') and |
153: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
154: | PARAMETERS |
155: | p_ps_id Payment Schedule Id for which current |
156: | applications are required |
157: | p_type The type of current applications required - |

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

254: | CurrentRevDistribution |
255: | DESCRIPTION |
256: | Populates PL/SQL tables with the current 'revenue' distribution of |
257: | the given Payment Schedule for a given type. |
258: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
259: | records of account_class 'REV' and adjustments where |
260: | line_adjusted IS NOT NULL |
261: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
262: | records of account_class 'TAX' and adjustments where |

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

257: | the given Payment Schedule for a given type. |
258: | For type 'LINE' the distributions include ra_cust_trx_line_gl_dist |
259: | records of account_class 'REV' and adjustments where |
260: | line_adjusted IS NOT NULL |
261: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
262: | records of account_class 'TAX' and adjustments where |
263: | tax_adjusted IS NOT NULL |
264: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
265: | records of account_class 'FREIGHT' and adjustments where |

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

260: | line_adjusted IS NOT NULL |
261: | For type 'TAX' the distributions include ra_cust_trx_line_gl_dist |
262: | records of account_class 'TAX' and adjustments where |
263: | tax_adjusted IS NOT NULL |
264: | For type 'FREIGHT' the distributions include ra_cust_trx_line_gl_dist|
265: | records of account_class 'FREIGHT' and adjustments where |
266: | freight_adjusted IS NOT NULL |
267: | For type 'CHARGES' the distributions include adjustments where |
268: | receivables_charges_adjusted IS NOT NULL |

Line 270: | ra_cust_trx_line_gl_dist records and all adjustments |

266: | freight_adjusted IS NOT NULL |
267: | For type 'CHARGES' the distributions include adjustments where |
268: | receivables_charges_adjusted IS NOT NULL |
269: | For type 'INVOICE' the distributions include all |
270: | ra_cust_trx_line_gl_dist records and all adjustments |
271: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
272: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
273: | |
274: | PARAMETERS |

Line 272: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |

268: | receivables_charges_adjusted IS NOT NULL |
269: | For type 'INVOICE' the distributions include all |
270: | ra_cust_trx_line_gl_dist records and all adjustments |
271: | The lines are returned ordered by Source ('GL' then 'ADJ' and then |
272: | source_id (ra_cust_trx_line_gl_dist_id or adjustment_id ) |
273: | |
274: | PARAMETERS |
275: | p_Report RECORD type that contains posting parameters |
276: | p_ps_id payment_schedule_id for which distribution is required |

Line 328: FROM ra_cust_trx_line_gl_dist ctlgd

324: ctlgd.code_combination_id ccid,
325: substrb(decode(ctlgd.account_class,
326: 'REV','LINE',
327: ctlgd.account_class),1,15) accntclass
328: FROM ra_cust_trx_line_gl_dist ctlgd
329: WHERE ctlgd.customer_trx_id = cp_ctid
330: AND ctlgd.account_class IN ( 'REV', 'TAX', 'FREIGHT','CHARGES' ) -- we are only interested in these classes
331: AND ctlgd.account_class = DECODE
332: (

Line 2655: , ra_cust_trx_line_gl_dist_s.nextval

2651: SELECT ar_cash_receipt_history_s.nextval
2652: , ar_receivable_applications_s.nextval
2653: , ar_misc_cash_distributions_s.nextval
2654: , ar_adjustments_s.nextval
2655: , ra_cust_trx_line_gl_dist_s.nextval
2656: INTO l_Report.NxtCashReceiptHistoryId
2657: , l_Report.NxtReceivableApplicationId
2658: , l_Report.NxtMiscCashDistributionId
2659: , l_Report.NxtAdjustmentId