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 1625: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;

1621: l_org_id NUMBER:= p_rcpt_rec.org_id;
1622: l_contract_number okc_k_headers_all_b.contract_number%TYPE;
1623: l_cons_inv_number okl_cnsld_ar_hdrs_all_b.consolidated_invoice_number%TYPE;
1624: l_ar_inv_number ra_customer_trx_all.trx_number%TYPE;
1625: l_ar_invoice_line_id RA_CUSTOMER_TRX_LINES_ALL.CUSTOMER_TRX_LINE_ID%TYPE;
1626:
1627:
1628: l_appl_tbl APPL_TBL_TYPE DEFAULT p_appl_tbl;
1629: l_okl_rcpt_tbl line_appl_tbl_type;

Line 1691: FROM RA_CUSTOMER_TRX_LINES_ALL

1687: AND org_id = cp_org_id;
1688:
1689: CURSOR c_ar_inv_line_id(cp_ar_inv_id IN NUMBER, cp_org_id IN NUMBER) IS
1690: SELECT CUSTOMER_TRX_LINE_ID
1691: FROM RA_CUSTOMER_TRX_LINES_ALL
1692: WHERE CUSTOMER_TRX_ID = cp_ar_inv_id
1693: AND ORG_ID = cp_org_id
1694: AND LINE_TYPE = 'LINE'
1695: AND ROWNUM = 1;