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.JAI_RCV_TAX_PKG dependencies on JAI_MTL_TRXS

Line 451: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS

447: select abs(transaction_quantity) , transaction_uom , original_transaction_temp_id , prior_cost
448: from mtl_material_transactions
449: where transaction_id = cp_transaction_id ;
450:
451: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS
452: select *
453: from jai_mtl_trxs
454: where transaction_temp_id = cp_trx_temp_id;
455:

Line 453: from jai_mtl_trxs

449: where transaction_id = cp_transaction_id ;
450:
451: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS
452: select *
453: from jai_mtl_trxs
454: where transaction_temp_id = cp_trx_temp_id;
455:
456: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;
457:

Line 456: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;

452: select *
453: from jai_mtl_trxs
454: where transaction_temp_id = cp_trx_temp_id;
455:
456: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;
457:
458: cursor c_jai_cmn_lines(cp_shipment_num VARCHAR2) IS
459: SELECT *
460: FROM jai_cmn_lines

Line 1874: OPEN c_jai_mtl_Trxs(ln_orig_id);

1870: /*
1871: ln_orig_id : this field has the original_transaction_Temp_id
1872: */
1873:
1874: OPEN c_jai_mtl_Trxs(ln_orig_id);
1875: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1876: CLOSE c_jai_mtl_Trxs;
1877:
1878: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/

Line 1875: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;

1871: ln_orig_id : this field has the original_transaction_Temp_id
1872: */
1873:
1874: OPEN c_jai_mtl_Trxs(ln_orig_id);
1875: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1876: CLOSE c_jai_mtl_Trxs;
1877:
1878: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/
1879:

Line 1876: CLOSE c_jai_mtl_Trxs;

1872: */
1873:
1874: OPEN c_jai_mtl_Trxs(ln_orig_id);
1875: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1876: CLOSE c_jai_mtl_Trxs;
1877:
1878: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/
1879:
1880: END IF; --End if for p_source_document_code

Line 2432: OPEN c_jai_mtl_Trxs(ln_orig_id);

2428: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2429: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2430: CLOSE c_get_inv_trx_info;
2431:
2432: OPEN c_jai_mtl_Trxs(ln_orig_id);
2433: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2434: CLOSE c_jai_mtl_Trxs;
2435:
2436: v_loc_quantity := ln_trx_qty;

Line 2433: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;

2429: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2430: CLOSE c_get_inv_trx_info;
2431:
2432: OPEN c_jai_mtl_Trxs(ln_orig_id);
2433: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2434: CLOSE c_jai_mtl_Trxs;
2435:
2436: v_loc_quantity := ln_trx_qty;
2437:

Line 2434: CLOSE c_jai_mtl_Trxs;

2430: CLOSE c_get_inv_trx_info;
2431:
2432: OPEN c_jai_mtl_Trxs(ln_orig_id);
2433: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2434: CLOSE c_jai_mtl_Trxs;
2435:
2436: v_loc_quantity := ln_trx_qty;
2437:
2438: update jai_rcv_lines

Line 2439: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,

2435:
2436: v_loc_quantity := ln_trx_qty;
2437:
2438: update jai_rcv_lines
2439: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,
2440: excise_invoice_Date = r_jai_mtl_trxs.creation_Date
2441: where shipment_line_id = p_shipment_line_id;
2442:
2443: OPEN c_po_tax_cur FOR

Line 2440: excise_invoice_Date = r_jai_mtl_trxs.creation_Date

2436: v_loc_quantity := ln_trx_qty;
2437:
2438: update jai_rcv_lines
2439: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,
2440: excise_invoice_Date = r_jai_mtl_trxs.creation_Date
2441: where shipment_line_id = p_shipment_line_id;
2442:
2443: OPEN c_po_tax_cur FOR
2444: SELECT tax_line_no,

Line 2453: NVL(jtc.vendor_id,r_jai_mtl_Trxs.from_organization) vendor_id, /* 6030615*/

2449: DECODE(SIGN(jtc.end_date - SYSDATE), -1, 0, llt.tax_amt) tax_amount,
2450: llt.tax_type,
2451: jtc.tax_name,
2452: llt.modvat_flag,
2453: NVL(jtc.vendor_id,r_jai_mtl_Trxs.from_organization) vendor_id, /* 6030615*/
2454: jtc.vendor_id tax_vendor_id,
2455: jtc.vendor_site_id,
2456: llt.currency_code currency ,
2457: jtc.rounding_factor,

Line 2540: v_price_override:=r_jai_mtl_Trxs.selling_price;

2536: ( p_vendor_id, p_vendor_site_id, v_item_id, p_uom_code ),v_price_override);
2537:
2538: IF p_source_document_code = 'INVENTORY'
2539: THEN
2540: v_price_override:=r_jai_mtl_Trxs.selling_price;
2541: v_assessable_value:=NVL(r_jai_mtl_Trxs.assessable_Value,v_price_override);
2542: END IF;
2543:
2544:

Line 2541: v_assessable_value:=NVL(r_jai_mtl_Trxs.assessable_Value,v_price_override);

2537:
2538: IF p_source_document_code = 'INVENTORY'
2539: THEN
2540: v_price_override:=r_jai_mtl_Trxs.selling_price;
2541: v_assessable_value:=NVL(r_jai_mtl_Trxs.assessable_Value,v_price_override);
2542: END IF;
2543:
2544:
2545: OPEN c_jai_cmn_lines(v_shipment_num);

Line 2570: v_price_override := r_jai_mtl_Trxs.selling_price;

2566: ln_vat_assess_value:=v_price_override;
2567: END IF;
2568:
2569: else /*rchandan - 6030615*/
2570: v_price_override := r_jai_mtl_Trxs.selling_price;
2571: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override); --added /r_jai_mtl_Trxs.quantity for bug#8880760
2572: /*vat assessable value in interorg is stored as vat_assessable_value per qty *shipment qty,hence divided with r_jai_mtl_Trxs.quantity for bug#8880760*/
2573: --r_jai_mtl_Trxs.quantity to get the per qty vat asse
2574: end if;

Line 2571: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override); --added /r_jai_mtl_Trxs.quantity for bug#8880760

2567: END IF;
2568:
2569: else /*rchandan - 6030615*/
2570: v_price_override := r_jai_mtl_Trxs.selling_price;
2571: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override); --added /r_jai_mtl_Trxs.quantity for bug#8880760
2572: /*vat assessable value in interorg is stored as vat_assessable_value per qty *shipment qty,hence divided with r_jai_mtl_Trxs.quantity for bug#8880760*/
2573: --r_jai_mtl_Trxs.quantity to get the per qty vat asse
2574: end if;
2575:

Line 2572: /vat assessable value in interorg is stored as vat_assessable_value per qty shipment qty,hence divided with r_jai_mtl_Trxs.quantity for bug#8880760*/

2568:
2569: else /*rchandan - 6030615*/
2570: v_price_override := r_jai_mtl_Trxs.selling_price;
2571: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override); --added /r_jai_mtl_Trxs.quantity for bug#8880760
2572: /*vat assessable value in interorg is stored as vat_assessable_value per qty *shipment qty,hence divided with r_jai_mtl_Trxs.quantity for bug#8880760*/
2573: --r_jai_mtl_Trxs.quantity to get the per qty vat asse
2574: end if;
2575:
2576: --Add by Xiao for GST refer to bug#10043656 on 14-Sep-2010, begin

Line 2573: --r_jai_mtl_Trxs.quantity to get the per qty vat asse

2569: else /*rchandan - 6030615*/
2570: v_price_override := r_jai_mtl_Trxs.selling_price;
2571: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override); --added /r_jai_mtl_Trxs.quantity for bug#8880760
2572: /*vat assessable value in interorg is stored as vat_assessable_value per qty *shipment qty,hence divided with r_jai_mtl_Trxs.quantity for bug#8880760*/
2573: --r_jai_mtl_Trxs.quantity to get the per qty vat asse
2574: end if;
2575:
2576: --Add by Xiao for GST refer to bug#10043656 on 14-Sep-2010, begin
2577: ------------------------------------------------------------------------------

Line 2593: v_price_override := r_jai_mtl_Trxs.selling_price;

2589: THEN
2590: ln_gst_assess_value:=v_price_override;
2591: END IF;
2592: ELSE
2593: v_price_override := r_jai_mtl_Trxs.selling_price;
2594: ln_gst_assess_value:=NVL(r_jai_mtl_Trxs.gst_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override);
2595: END IF;
2596: */
2597: ------------------------------------------------------------------------------

Line 2594: ln_gst_assess_value:=NVL(r_jai_mtl_Trxs.gst_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override);

2590: ln_gst_assess_value:=v_price_override;
2591: END IF;
2592: ELSE
2593: v_price_override := r_jai_mtl_Trxs.selling_price;
2594: ln_gst_assess_value:=NVL(r_jai_mtl_Trxs.gst_assessable_Value/r_jai_mtl_Trxs.quantity,v_price_override);
2595: END IF;
2596: */
2597: ------------------------------------------------------------------------------
2598: --Add by Xiao for GST refer to bug#10043656 on 14-Sep-2010, end

Line 2644: v_price_override := r_jai_mtl_Trxs.selling_price;

2640: If p_source_document_code = 'INVENTORY'/*rchandan - 6030615..start*
2641: and po_lines_rec.regime_code <> jai_constants.vat_regime
2642: and upper(po_lines_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE')
2643: THEN
2644: v_price_override := r_jai_mtl_Trxs.selling_price;
2645: END IF;
2646: -- bug 6488829 uncommented the if condition *
2647: IF p_source_document_code = 'INVENTORY' AND po_lines_rec.regime_code = jai_constants.vat_regime THEN
2648: v_precedence_0 := v_price_override;

Line 2684: ln_vat_assess_val_defined:=r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity; -- added by nkodakan for bug 14590356.

2680: ln_curflag := 1; --Add by Kevin Cheng for bug 6853787 Mar 5, 2008
2681:
2682: --added by pezheng for bug 10630487, v_precedence_0 should be calculated out of the tax loop rather than in
2683: v_assessable_val_defined := jai_cmn_setup_pkg.get_po_assessable_value( p_vendor_id, p_vendor_site_id, v_item_id, p_uom_code ); -- added by nkodakan for bug 14590356.
2684: ln_vat_assess_val_defined:=r_jai_mtl_Trxs.vat_assessable_Value/r_jai_mtl_Trxs.quantity; -- added by nkodakan for bug 14590356.
2685: -- v_assessable_val_defined,ln_vat_assess_val_defined holds the assessable if it is defined..If not defined then its value becomes null;
2686: IF v_po_currency <> v_func_currency THEN
2687: -- by nkodakan for the bug 14590356 starts
2688: IF (v_assessable_val_defined is null) THEN