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 AR_CASH_BASIS_DISTRIBUTIONS

Line 229: | The information is extracted from the ar_cash_basis_distributions |

225: | DESCRIPTION |
226: | Populates the TABLE types passed to the procedure with the total |
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

Line 277: FROM ar_cash_basis_distributions cbd

273: cbd.source Source,
274: cbd.source_id SourceId,
275: NVL(SUM( DECODE(cbd.source,
276: 'UNA', cbd.amount, 0 )),0) UnallocatedAmt
277: FROM ar_cash_basis_distributions cbd
278: WHERE cbd.payment_schedule_id = p_ps_id
279: AND cbd.type = p_type
280: AND cbd.posting_control_id+0 > 0
281: GROUP BY cbd.source,

Line 630: | ar_cash_basis_distributions, and a record into gl_interface |

626: | PRIVATE PROCEDURE |
627: | CreateDistribution |
628: | DESCRIPTION |
629: | Creates a distribution by inserting a record into |
630: | ar_cash_basis_distributions, and a record into gl_interface |
631: | PARAMETERS |
632: | |
633: | EXCEPTIONS RAISED |
634: | |

Line 656: CashBasisDistributionId ar_cash_basis_distributions.cash_basis_distribution_id%TYPE;

652: p_Type IN VARCHAR2,
653: p_Ccid IN NUMBER,
654: p_AccntClass IN VARCHAR2,
655: p_AmountAppFrom IN NUMBER ) IS
656: CashBasisDistributionId ar_cash_basis_distributions.cash_basis_distribution_id%TYPE;
657: l_gl_interface gl_interface%ROWTYPE;
658: l_gl_interface_null gl_interface%ROWTYPE;
659: BEGIN
660: IF p_Amount = 0 AND p_AcctdAmount = 0 THEN

Line 664: SELECT ar_cash_basis_distributions_s.NEXTVAL

660: IF p_Amount = 0 AND p_AcctdAmount = 0 THEN
661: RETURN;
662: END IF;
663:
664: SELECT ar_cash_basis_distributions_s.NEXTVAL
665: INTO CashBasisDistributionId
666: FROM dual;
667:
668: BEGIN

Line 673: INSERT INTO ar_cash_basis_distributions

669:
670: IF (NVL(p_Post.SetOfBooksType,'P') <> 'R')
671: THEN
672: /* Primary SOB */
673: INSERT INTO ar_cash_basis_distributions
674: (
675: cash_basis_distribution_id,
676: created_by,
677: creation_date,

Line 875: l_gl_interface.reference30 := 'AR_CASH_BASIS_DISTRIBUTIONS';

871: l_gl_interface.reference29 := 'CMAPP_APP_'||p_Trx.Class||'_'||p_Source||'_'||p_Type;
872: END IF;
873: END IF;
874:
875: l_gl_interface.reference30 := 'AR_CASH_BASIS_DISTRIBUTIONS';
876:
877: CreateInterface( l_gl_interface );
878:
879: EXCEPTION

Line 955: AppToLineThisTime NUMBER; -- the actual amount posted, and stored in ar_cash_basis_distributions

951: -- the final NewAppToLine is adjusted
952: -- so that the value of RunningNewAppToLine is equal to
953: -- GrandTotalApplied
954: GrandTotalApplied NUMBER;
955: AppToLineThisTime NUMBER; -- the actual amount posted, and stored in ar_cash_basis_distributions
956: AcctdAppToLineThisTime NUMBER;
957: RunningAppToLineThisTime NUMBER := 0;
958: RunningAcctdAppToLineThisTime NUMBER := 0;
959: -- Bug 1829871

Line 2562: DELETE FROM ar_cash_basis_distributions

2558: AND decode(p_CategoryCode,
2559: 'CMAPP',customer_trx_id,
2560: 'TRADE', cash_receipt_id) = p_BalanceId;
2561:
2562: DELETE FROM ar_cash_basis_distributions
2563: WHERE cash_basis_distribution_id IN (
2564: SELECT reference23
2565: FROM gl_interface
2566: WHERE reference22 = p_BalanceId

Line 2571: AND reference30 = 'AR_CASH_BASIS_DISTRIBUTIONS'

2567: AND reference28 = p_CategoryCode
2568: AND set_of_books_id = p_Post.SetOfBooksId
2569: AND group_id = p_Post.PostingControlId
2570: AND user_je_source_name = p_Post.UserSource
2571: AND reference30 = 'AR_CASH_BASIS_DISTRIBUTIONS'
2572: );
2573: /* reporting sob */
2574: ELSE
2575: --{BUG4301323

Line 2607: AND reference30 = 'AR_CASH_BASIS_DISTRIBUTIONS'

2603: AND reference28 = p_CategoryCode
2604: AND set_of_books_id = p_Post.SetOfBooksId
2605: AND group_id = p_Post.PostingControlId
2606: AND user_je_source_name = p_Post.UserSource
2607: AND reference30 = 'AR_CASH_BASIS_DISTRIBUTIONS'
2608: );
2609: */
2610: END IF;
2611: END IF;

Line 2704: IF RInt.TableName = 'AR_CASH_BASIS_DISTRIBUTIONS'

2700: LOOP
2701: arp_standard.debug( 'Out Of balance:'||Rbal.CurrencyCode||' BalanceId:'||RBal.BalanceId );
2702: FOR RInt IN CInt( RBal.BalanceId, Rbal.CategoryCode )
2703: LOOP
2704: IF RInt.TableName = 'AR_CASH_BASIS_DISTRIBUTIONS'
2705: THEN
2706:
2707: IF p_Post.SetOfBooksType <> 'R'
2708: THEN

Line 2712: FROM ar_cash_basis_distributions cbd

2708: THEN
2709: /* Primary */
2710: SELECT cbd.receivable_application_id
2711: INTO l_ReceivableApplicationId
2712: FROM ar_cash_basis_distributions cbd
2713: WHERE cbd.cash_basis_distribution_id = RInt.Id;
2714: ELSE
2715: --{BUG4301323
2716: NULL;

Line 2757: WHERE table_name = 'AR_CASH_BASIS_DISTRIBUTIONS'

2753: --
2754: CURSOR SelColumn IS
2755: SELECT column_id
2756: FROM user_tab_columns
2757: WHERE table_name = 'AR_CASH_BASIS_DISTRIBUTIONS'
2758: AND column_name = 'CUSTOMER_TRX_LINE_ID';
2759: --
2760: BEGIN
2761: