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.PON_EMD_AR_INTEGRATION_GRP dependencies on AR_CASH_RECEIPTS_ALL

Line 2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;

2171: x_location hz_locations.city%TYPE := NULL;
2172:
2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;

Line 2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

2172:
2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;

Line 2177: x_receipt_status ar_cash_receipts_all.status%TYPE;

2173:
2174:
2175: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2176: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2177: x_receipt_status ar_cash_receipts_all.status%TYPE;
2178: l_unapply_in_rec UNAPPLY_INFO_IN_RECTYPE;
2179: l_unapply_out_rec UNAPPLY_INFO_OUT_RECTYPE;
2180: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2181: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;

2778: l_parent_trx_number pon_emd_transactions.CUST_TRX_NUMBER%TYPE;
2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:

Line 2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;

2779: l_parent_trx_id pon_emd_transactions.CUST_TRX_ID%TYPE;
2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 2784: x_receipt_status ar_cash_receipts_all.status%TYPE;

2780: l_parent_trx_line_id pon_emd_transactions.CUST_TRX_LINE_ID%TYPE;
2781:
2782: x_receipt_num ar_cash_receipts_all.receipt_number%TYPE;
2783: x_cash_receipt_id ar_cash_receipts_all.cash_receipt_id%TYPE;
2784: x_receipt_status ar_cash_receipts_all.status%TYPE;
2785: x_receivable_app_id ar_receivable_applications.receivable_application_id%TYPE;
2786:
2787: x_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;
2788: l_deposit_payment_type_code pon_emd_transactions.PAYMENT_TYPE_CODE%TYPE;

Line 4332: ar_cash_receipts_all acr

4328: x_receivable_app_id
4329: from ar_receivable_applications_all arp,
4330: ra_customer_trx_all rct,
4331: ra_cust_trx_types_all ctyp,
4332: ar_cash_receipts_all acr
4333: where arp.applied_customer_trx_id = p_parent_trx_id
4334: AND arp.org_id = p_org_id
4335: AND arp.status = 'APP'
4336: AND arp.applied_customer_trx_id = rct.customer_trx_id

Line 4364: ar_cash_receipts_all acr

4360: acrh.status
4361: INTO x_receipt_num,
4362: x_receipt_status
4363: FROM ar_cash_Receipt_history_all acrh,
4364: ar_cash_receipts_all acr
4365: WHERE acrh.cash_receipt_id =acr.cash_receipt_id
4366: AND acrh.current_record_flag = 'Y'
4367: AND acrh.status = 'CLEARED'
4368: AND acr.cash_receipt_id = x_cash_receipt_id;