APPS.OKL_RECEIPTS_PVT dependencies on RA_CUSTOMER_TRX_LINES_ALL

Line 550: from ra_customer_trx_lines_all a,

546: where cash_receipt_id=p_cash_rcpt_id;
547:
548: CURSOR c_fetch_inv_currency(p_customer_trx_line_id IN NUMBER) IS
549: select b.INVOICE_CURRENCY_CODE
550: from ra_customer_trx_lines_all a,
551: ra_customer_trx_all b
552: where a.customer_trx_line_id=p_customer_trx_line_id
553: and a.customer_trx_id = b.customer_trx_id;
554:

Line 583: FROM RA_CUSTOMER_TRX_LINES_ALL

579: WHERE rcpt_Line.Cash_Receipt_Id = p_cash_receipt_id;
580:
581: CURSOR c_get_orig_freight_amount(p_customer_trx_id IN NUMBER) IS
582: SELECT NVL(SUM(AMOUNT_DUE_ORIGINAL),0)
583: FROM RA_CUSTOMER_TRX_LINES_ALL
584: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
585: AND LINE_TYPE = 'FREIGHT';
586:
587: CURSOR c_get_orig_charges_amount(p_customer_trx_id IN NUMBER) IS

Line 589: FROM RA_CUSTOMER_TRX_LINES_ALL

585: AND LINE_TYPE = 'FREIGHT';
586:
587: CURSOR c_get_orig_charges_amount(p_customer_trx_id IN NUMBER) IS
588: SELECT NVL(SUM(AMOUNT_DUE_ORIGINAL),0)
589: FROM RA_CUSTOMER_TRX_LINES_ALL
590: WHERE CUSTOMER_TRX_ID = p_customer_trx_id
591: AND LINE_TYPE = 'CHARGES';
592:
593: BEGIN

Line 1229: FROM RA_CUSTOMER_TRX_LINES_ALL

1225: AND NVL(DISPLAY,'N') = 'Y';
1226:
1227: CURSOR c_get_cust_trx_id (p_line_id IN NUMBER) IS
1228: SELECT CUSTOMER_TRX_ID
1229: FROM RA_CUSTOMER_TRX_LINES_ALL
1230: WHERE CUSTOMER_TRX_LINE_ID = p_line_id;
1231:
1232:
1233: l_onacc_appplication_id NUMBER;

Line 1682: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

1678: l_org_id NUMBER:= p_rcpt_rec.org_id;
1679: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1680: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1681: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1682: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1683:
1684:
1685: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;
1686: l_okl_rcpt_tbl line_appl_tbl_type;

Line 1748: FROM RA_CUSTOMER_TRX_LINES_ALL

1744: AND org_id = cp_org_id;
1745:
1746: CURSOR c_ar_inv_line_id(cp_ar_inv_id IN NUMBER, cp_org_id IN NUMBER) IS
1747: SELECT CUSTOMER_TRX_LINE_ID
1748: FROM RA_CUSTOMER_TRX_LINES_ALL
1749: WHERE CUSTOMER_TRX_ID = cp_ar_inv_id
1750: AND ORG_ID = cp_org_id
1751: AND LINE_TYPE = 'LINE'
1752: AND ROWNUM = 1;