[Home] [Help]
1089: cen.transaction_id ,
1090: rcv.excise_invoice_no ,
1091: rcv.excise_invoice_date
1092: from
1093: JAI_RCV_TRANSACTIONS rcv,
1094: JAI_RCV_CENVAT_CLAIMS cen
1095: where
1096: rcv.shipment_line_id=cen.shipment_line_id
1097: and rcv.item_class in ('CGIN','CGEX')
3569: SELECT * from JAI_RCV_LINE_TAXES
3570: WHERE shipment_line_id = cp_shipment_line_id;
3571:
3572: CURSOR c_trx (cp_transaction_id IN NUMBER) IS
3573: SELECT * from JAI_RCV_TRANSACTIONS
3574: WHERE transaction_id = cp_transaction_id ;
3575:
3576: CURSOR c_base_trx (cp_transaction_id IN NUMBER) IS
3577: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
4393: tax_transaction_id,
4394: parent_transaction_type,
4395: currency_conversion_rate,
4396: quantity
4397: FROM JAI_RCV_TRANSACTIONS
4398: WHERE shipment_line_id = NVL(cp_shipment_line_id, shipment_line_id)
4399: AND transaction_id = NVL(cp_transaction_id, transaction_id)
4400: and organization_id=p_organization_id
4401: and inventory_item_id=p_inventory_item_id
4410:
4411:
4412:
4413: CURSOR cur_tax(cp_shipment_line_id IN rcv_transactions.shipment_line_id%TYPE,
4414: cp_currency_conversion_rate IN JAI_RCV_TRANSACTIONS.currency_conversion_rate%TYPE)
4415: IS
4416: SELECT ROUND(
4417: DECODE(a.currency, jai_constants.func_curr, a.tax_amount, a.tax_amount*cp_currency_conversion_rate),
4418: NVL(b.rounding_factor, 0)
4708: ln_entered_cr NUMBER;
4709: ld_accounting_date DATE;
4710: ln_repository_id jai_rgm_trx_records.repository_id%TYPE;
4711: lv_destination VARCHAR2(10);
4712: lv_code_path JAI_RCV_TRANSACTIONS.codepath%TYPE;
4713: lv_process_status VARCHAR2(2);
4714: lv_process_message VARCHAR2(1000);
4715: ln_regime_id jai_rgm_definitions.regime_id%TYPE;
4716: