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_RECEIVABLE_APPLICATIONS

Line 36: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,

32: -- RECORD holder for pertinent information from a receivable application
33: -- of status = 'APP'
34: TYPE ApplicationType IS RECORD
35: (
36: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
37: GLDate DATE, -- the gl date of the application
38: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
39: AppType ar_receivable_applications.application_type%TYPE
40: );

Line 38: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,

34: TYPE ApplicationType IS RECORD
35: (
36: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
37: GLDate DATE, -- the gl date of the application
38: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
39: AppType ar_receivable_applications.application_type%TYPE
40: );
41: --
42: -- holds ApplicationAmount values

Line 39: AppType ar_receivable_applications.application_type%TYPE

35: (
36: ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE,
37: GLDate DATE, -- the gl date of the application
38: UssglTransactionCode ar_receivable_applications.ussgl_transaction_code%TYPE,
39: AppType ar_receivable_applications.application_type%TYPE
40: );
41: --
42: -- holds ApplicationAmount values
43: --

Line 1207: -- post ar_receivable_applications that have status UNAPP, UNID, ACC,OTHER ACC

1203: RAISE;
1204: END;
1205: --
1206: --
1207: -- post ar_receivable_applications that have status UNAPP, UNID, ACC,OTHER ACC
1208: --
1209: /*---------------------------------------------------------------------------*
1210: | PRIVATE PROCEDURE |
1211: | PostNonDistApplications |

Line 1213: | post unposted ar_receivable_applications records |

1209: /*---------------------------------------------------------------------------*
1210: | PRIVATE PROCEDURE |
1211: | PostNonDistApplications |
1212: | DESCRIPTION |
1213: | post unposted ar_receivable_applications records |
1214: | |
1215: | |
1216: | PARAMETERS |
1217: | |

Line 1254: FROM ar_receivable_applications ra,

1250: ra.amount_applied_from AmountAppFrom,
1251: ra.acctd_amount_applied_from AcctdAmount,
1252: ra.code_combination_id CodeCombinationId,
1253: ra.status Status
1254: FROM ar_receivable_applications ra,
1255: ar_cash_receipts cr
1256: WHERE ra.posting_control_id = p_Post.UnpostedPostingControlId
1257: AND ra.gl_date BETWEEN p_Post.GlDateFrom
1258: AND p_Post.GlDateTo

Line 1289: FROM ar_receivable_applications ra,

1285: ra.amount_applied_from AmountAppFrom,
1286: ra_mrc.acctd_amount_applied_from AcctdAmount,
1287: ra.code_combination_id CodeCombinationId,
1288: ra_mrc.status Status
1289: FROM ar_receivable_applications ra,
1290: ar_mc_receivable_apps ra_mrc,
1291: ar_cash_receipts cr
1292: WHERE ra_mrc.posting_control_id = p_Post.UnpostedPostingControlId
1293: AND ra.gl_date BETWEEN p_Post.GlDateFrom

Line 1312: arp_standard.debug( ' AR_RECEIVABLE_APPLICATIONS (non-app)...' );

1308: l_gl_interface gl_interface%ROWTYPE;
1309: l_gl_interface_null gl_interface%ROWTYPE;
1310: BEGIN
1311: arp_standard.debug( ' ' );
1312: arp_standard.debug( ' AR_RECEIVABLE_APPLICATIONS (non-app)...' );
1313:
1314: -- bug3769452 modified IF condition
1315: IF (p_Post.SetOfBooksType <> 'R')
1316: THEN

Line 1412: l_gl_interface.reference30 := 'AR_RECEIVABLE_APPLICATIONS' ;

1408: ELSE
1409: l_gl_interface.reference28 := 'CCURR';
1410: l_gl_interface.reference29 := 'CCURR_APP';
1411: END IF;
1412: l_gl_interface.reference30 := 'AR_RECEIVABLE_APPLICATIONS' ;
1413:
1414: CreateInterface(l_gl_interface) ;
1415:
1416: EXCEPTION

Line 1435: UPDATE ar_receivable_applications

1431: arp_standard.debug('RRa.Status:'||RRa.Status );
1432: RAISE;
1433: END;
1434:
1435: UPDATE ar_receivable_applications
1436: SET posting_control_id = p_Post.PostingControlId,
1437: gl_posted_date = p_Post.GlPostedDate
1438: WHERE rowid = RRa.RaRowid;
1439:

Line 1542: -- l_gl_interface.reference30 := 'AR_RECEIVABLE_APPLICATIONS' ;

1538: -- l_gl_interface.reference28 := 'CCURR';
1539: -- l_gl_interface.reference29 := 'CCURR_APP';
1540: -- END IF;
1541:
1542: -- l_gl_interface.reference30 := 'AR_RECEIVABLE_APPLICATIONS' ;
1543:
1544: -- CreateInterface(l_gl_interface) ;
1545:
1546: -- EXCEPTION

Line 1588: | post unposted ar_receivable_applications records |

1584: | PRIVATE PROCEDURE |
1585: | PostDistributedApplications |
1586: | |
1587: | DESCRIPTION |
1588: | post unposted ar_receivable_applications records |
1589: | We need to have ORDER BY clause in the select statement because |
1590: | when comparing with Journal Entry report, they need to match, |
1591: | If order by is not used, there will be rounding difference. |
1592: | |

Line 1608: | ar_receivable_applications table.

Line 1708: FROM ar_receivable_applications ra,

1704: '1', NVL(ra.receivables_charges_applied,0),
1705: '2', NVL(-ra.receivables_charges_applied,0)
1706: ) ChargesApplied,
1707: ct.org_id OrgId
1708: FROM ar_receivable_applications ra,
1709: ra_cust_trx_types ctt,
1710: ra_customer_trx ct,
1711: ar_cash_receipts cr,
1712: ar_cash_receipt_history crh,

Line 1910: UPDATE ar_receivable_applications

1906:
1907: IF l_Trx.CmPsIdFlag <> 'Y'
1908: THEN
1909:
1910: UPDATE ar_receivable_applications
1911: SET posting_control_id = p_Post.PostingControlId,
1912: gl_posted_date = p_Post.GlPostedDate
1913: WHERE rowid = l_Rowid;
1914:

Line 2554: UPDATE ar_receivable_applications

2550: THEN
2551: -- bug3769452 modified IF condition
2552: IF (p_Post.SetOfBooksType <> 'R')
2553: THEN
2554: UPDATE ar_receivable_applications
2555: SET gl_posted_date = NULL,
2556: posting_control_id = p_Post.UnpostedPostingControlId
2557: WHERE posting_control_id = p_Post.PostingControlId
2558: AND decode(p_CategoryCode,

Line 2585: FROM ar_receivable_applications ra

2581: WHERE posting_control_id = p_Post.PostingControlId
2582: AND set_of_books_id = p_Post.SetOfBooksId
2583: AND receivable_application_id IN (
2584: SELECT ra.receivable_application_id
2585: FROM ar_receivable_applications ra
2586: WHERE p_CategoryCode = 'CMAPP'
2587: AND ra.customer_trx_id = p_BalanceId
2588: UNION
2589: SELECT ra.receivable_application_id

Line 2590: FROM ar_receivable_applications ra

2586: WHERE p_CategoryCode = 'CMAPP'
2587: AND ra.customer_trx_id = p_BalanceId
2588: UNION
2589: SELECT ra.receivable_application_id
2590: FROM ar_receivable_applications ra
2591: WHERE p_CategoryCode = 'TRADE'
2592: AND ra.cash_receipt_id = p_BalanceId);
2593: */
2594: /* Able to use MRC view here because view contains

Line 2692: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;

2688: AND i.reference28 = p_CategoryCode
2689: ORDER BY i.reference30,
2690: i.reference23;
2691: --
2692: l_ReceivableApplicationId ar_receivable_applications.receivable_application_id%TYPE;
2693: BEGIN
2694: --
2695: arp_standard.debug( ' ----------------------------------------------------' );
2696: arp_standard.debug( ' Checking DR/CR balance...' );