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 429: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS

425: select abs(transaction_quantity) , transaction_uom , original_transaction_temp_id , prior_cost
426: from mtl_material_transactions
427: where transaction_id = cp_transaction_id ;
428:
429: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS
430: select *
431: from jai_mtl_trxs
432: where transaction_temp_id = cp_trx_temp_id;
433:

Line 431: from jai_mtl_trxs

427: where transaction_id = cp_transaction_id ;
428:
429: cursor c_jai_mtl_Trxs(cp_trx_temp_id NUMBER) IS
430: select *
431: from jai_mtl_trxs
432: where transaction_temp_id = cp_trx_temp_id;
433:
434: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;
435:

Line 434: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;

430: select *
431: from jai_mtl_trxs
432: where transaction_temp_id = cp_trx_temp_id;
433:
434: r_jai_mtl_Trxs c_jai_mtl_Trxs%rowtype;
435:
436: cursor c_jai_cmn_lines(cp_shipment_num VARCHAR2) IS
437: SELECT *
438: FROM jai_cmn_lines

Line 1658: OPEN c_jai_mtl_Trxs(ln_orig_id);

1654: /*
1655: ln_orig_id : this field has the original_transaction_Temp_id
1656: */
1657:
1658: OPEN c_jai_mtl_Trxs(ln_orig_id);
1659: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1660: CLOSE c_jai_mtl_Trxs;
1661:
1662: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/

Line 1659: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;

1655: ln_orig_id : this field has the original_transaction_Temp_id
1656: */
1657:
1658: OPEN c_jai_mtl_Trxs(ln_orig_id);
1659: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1660: CLOSE c_jai_mtl_Trxs;
1661:
1662: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/
1663:

Line 1660: CLOSE c_jai_mtl_Trxs;

1656: */
1657:
1658: OPEN c_jai_mtl_Trxs(ln_orig_id);
1659: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
1660: CLOSE c_jai_mtl_Trxs;
1661:
1662: v_po_uom := lv_trx_uom; /*rchandan for bug#6030615...end*/
1663:
1664: END IF; --End if for p_source_document_code

Line 2178: OPEN c_jai_mtl_Trxs(ln_orig_id);

2174: OPEN c_get_inv_trx_info(r_rec_ship_txn.mmt_transaction_id);
2175: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2176: CLOSE c_get_inv_trx_info;
2177:
2178: OPEN c_jai_mtl_Trxs(ln_orig_id);
2179: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2180: CLOSE c_jai_mtl_Trxs;
2181:
2182: v_loc_quantity := ln_trx_qty;

Line 2179: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;

2175: FETCH c_get_inv_trx_info INTO ln_trx_qty , lv_trx_uom , ln_orig_id , ln_item_cost;
2176: CLOSE c_get_inv_trx_info;
2177:
2178: OPEN c_jai_mtl_Trxs(ln_orig_id);
2179: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2180: CLOSE c_jai_mtl_Trxs;
2181:
2182: v_loc_quantity := ln_trx_qty;
2183:

Line 2180: CLOSE c_jai_mtl_Trxs;

2176: CLOSE c_get_inv_trx_info;
2177:
2178: OPEN c_jai_mtl_Trxs(ln_orig_id);
2179: FETCH c_jai_mtl_Trxs INTO r_jai_mtl_Trxs;
2180: CLOSE c_jai_mtl_Trxs;
2181:
2182: v_loc_quantity := ln_trx_qty;
2183:
2184: update jai_rcv_lines

Line 2185: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,

2181:
2182: v_loc_quantity := ln_trx_qty;
2183:
2184: update jai_rcv_lines
2185: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,
2186: excise_invoice_Date = r_jai_mtl_trxs.creation_Date
2187: where shipment_line_id = p_shipment_line_id;
2188:
2189: OPEN c_po_tax_cur FOR

Line 2186: excise_invoice_Date = r_jai_mtl_trxs.creation_Date

2182: v_loc_quantity := ln_trx_qty;
2183:
2184: update jai_rcv_lines
2185: set excise_invoice_no = r_jai_mtl_trxs.excise_invoice_no ,
2186: excise_invoice_Date = r_jai_mtl_trxs.creation_Date
2187: where shipment_line_id = p_shipment_line_id;
2188:
2189: OPEN c_po_tax_cur FOR
2190: SELECT tax_line_no,

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

2195: DECODE(SIGN(jtc.end_date - SYSDATE), -1, 0, llt.tax_amt) tax_amount,
2196: llt.tax_type,
2197: jtc.tax_name,
2198: llt.modvat_flag,
2199: NVL(jtc.vendor_id,r_jai_mtl_Trxs.from_organization) vendor_id, /* 6030615*/
2200: jtc.vendor_id tax_vendor_id,
2201: jtc.vendor_site_id,
2202: llt.currency_code currency ,
2203: jtc.rounding_factor,

Line 2249: v_price_override:=r_jai_mtl_Trxs.selling_price;

2245: ( p_vendor_id, p_vendor_site_id, v_item_id, p_uom_code ),v_price_override);
2246:
2247: IF p_source_document_code = 'INVENTORY'
2248: THEN
2249: v_price_override:=r_jai_mtl_Trxs.selling_price;
2250: v_assessable_value:=NVL(r_jai_mtl_Trxs.assessable_Value,v_price_override);
2251: END IF;
2252:
2253:

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

2246:
2247: IF p_source_document_code = 'INVENTORY'
2248: THEN
2249: v_price_override:=r_jai_mtl_Trxs.selling_price;
2250: v_assessable_value:=NVL(r_jai_mtl_Trxs.assessable_Value,v_price_override);
2251: END IF;
2252:
2253:
2254: OPEN c_jai_cmn_lines(v_shipment_num);

Line 2279: v_price_override := r_jai_mtl_Trxs.selling_price;

2275: ln_vat_assess_value:=v_price_override;
2276: END IF;
2277:
2278: else /*rchandan - 6030615*/
2279: v_price_override := r_jai_mtl_Trxs.selling_price;
2280: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value,v_price_override);
2281: end if;
2282:
2283: If p_source_document_code = 'INVENTORY'/*rchandan - 6030615..start*/

Line 2280: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value,v_price_override);

2276: END IF;
2277:
2278: else /*rchandan - 6030615*/
2279: v_price_override := r_jai_mtl_Trxs.selling_price;
2280: ln_vat_assess_value:=NVL(r_jai_mtl_Trxs.vat_assessable_Value,v_price_override);
2281: end if;
2282:
2283: If p_source_document_code = 'INVENTORY'/*rchandan - 6030615..start*/
2284: and po_lines_rec.regime_code <> jai_constants.vat_regime

Line 2287: v_price_override := r_jai_mtl_Trxs.selling_price;

2283: If p_source_document_code = 'INVENTORY'/*rchandan - 6030615..start*/
2284: and po_lines_rec.regime_code <> jai_constants.vat_regime
2285: and upper(po_lines_rec.tax_type) NOT IN ('EXCISE', 'ADDL. EXCISE', 'OTHER EXCISE')
2286: THEN
2287: v_price_override := r_jai_mtl_Trxs.selling_price;
2288: END IF;
2289: -- bug 6488829 uncommented the if condition */
2290: IF p_source_document_code = 'INVENTORY' AND po_lines_rec.regime_code = jai_constants.vat_regime THEN
2291: v_precedence_0 := v_price_override;