[Home] [Help]
1217: cen.transaction_id ,
1218: rcv.excise_invoice_no ,
1219: rcv.excise_invoice_date
1220: from
1221: JAI_RCV_TRANSACTIONS rcv,
1222: JAI_RCV_CENVAT_CLAIMS cen
1223: where
1224: rcv.shipment_line_id=cen.shipment_line_id
1225: and rcv.item_class in ('CGIN','CGEX')
3733: SELECT * from JAI_RCV_LINE_TAXES
3734: WHERE shipment_line_id = cp_shipment_line_id;
3735:
3736: CURSOR c_trx (cp_transaction_id IN NUMBER) IS
3737: SELECT * from JAI_RCV_TRANSACTIONS
3738: WHERE transaction_id = cp_transaction_id ;
3739:
3740: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3741: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
4838: tax_transaction_id,
4839: parent_transaction_type,
4840: currency_conversion_rate,
4841: quantity
4842: FROM JAI_RCV_TRANSACTIONS
4843: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4844: AND transaction_id = NVL(cp_transaction_id, transaction_id)
4845: and organization_id=p_organization_id
4846: and inventory_item_id=p_inventory_item_id
4855:
4856:
4857:
4858: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4859: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4860: IS
4861: SELECT DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate) tax_amount, --Removed Round condition by Bgowrava for Bug#8414075
4862: a.tax_type,
4863: a.tax_id,
5151: ln_entered_cr NUMBER;
5152: ld_accounting_date DATE;
5153: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
5154: lv_destination VARCHAR2(10);
5155: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
5156: lv_process_status VARCHAR2(2);
5157: lv_process_message VARCHAR2(1000);
5158: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
5159: