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_CMN_LINES

Line 436: cursor c_jai_cmn_lines(cp_shipment_num VARCHAR2) IS

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
439: WHERE po_line_location_id = p_line_location_id
440: AND shipment_number = cp_shipment_num;

Line 438: FROM jai_cmn_lines

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
439: WHERE po_line_location_id = p_line_location_id
440: AND shipment_number = cp_shipment_num;
441:
442: r_jai_cmn_lines c_jai_cmn_lines%rowtype;

Line 442: r_jai_cmn_lines c_jai_cmn_lines%rowtype;

438: FROM jai_cmn_lines
439: WHERE po_line_location_id = p_line_location_id
440: AND shipment_number = cp_shipment_num;
441:
442: r_jai_cmn_lines c_jai_cmn_lines%rowtype;
443:
444: ln_trx_qty number;
445: lv_trx_uom varchar2(20);
446: ln_orig_id number;

Line 1287: excise_inv_num to excise_inv_number in jai_cmn_lines table

1283:
1284: Dependency Due to this Bug : Yes.
1285: 51. 16-07-2007 iSuppleir forward porting
1286: Changed shipment_num to shipment_number
1287: excise_inv_num to excise_inv_number in jai_cmn_lines table
1288:
1289: 52. 01-08-2007 rchandan for bug#6030615 , Version 120.17
1290: Issue : Inter org Forward porting
1291:

Line 2107: OPEN c_jai_cmn_lines(v_shipment_num);

2103: ja_in_Receipt_lines procedure in case of an asbn receipt.
2104: */
2105:
2106:
2107: OPEN c_jai_cmn_lines(v_shipment_num);
2108: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2109: CLOSE c_jai_cmn_lines;
2110:
2111: v_loc_quantity := r_jai_cmn_lines.quantity;

Line 2108: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;

2104: */
2105:
2106:
2107: OPEN c_jai_cmn_lines(v_shipment_num);
2108: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2109: CLOSE c_jai_cmn_lines;
2110:
2111: v_loc_quantity := r_jai_cmn_lines.quantity;
2112:

Line 2109: CLOSE c_jai_cmn_lines;

2105:
2106:
2107: OPEN c_jai_cmn_lines(v_shipment_num);
2108: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2109: CLOSE c_jai_cmn_lines;
2110:
2111: v_loc_quantity := r_jai_cmn_lines.quantity;
2112:
2113: update JAI_RCV_LINES

Line 2111: v_loc_quantity := r_jai_cmn_lines.quantity;

2107: OPEN c_jai_cmn_lines(v_shipment_num);
2108: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2109: CLOSE c_jai_cmn_lines;
2110:
2111: v_loc_quantity := r_jai_cmn_lines.quantity;
2112:
2113: update JAI_RCV_LINES
2114: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2115: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date

Line 2114: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,

2110:
2111: v_loc_quantity := r_jai_cmn_lines.quantity;
2112:
2113: update JAI_RCV_LINES
2114: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2115: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date
2116: where shipment_line_id = p_shipment_line_id;
2117:
2118: OPEN c_po_tax_cur FOR

Line 2115: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date

2111: v_loc_quantity := r_jai_cmn_lines.quantity;
2112:
2113: update JAI_RCV_LINES
2114: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2115: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date
2116: where shipment_line_id = p_shipment_line_id;
2117:
2118: OPEN c_po_tax_cur FOR
2119: SELECT tax_line_no,

Line 2146: jai_cmn_lines cml,

2142: llt.precedence_8,
2143: llt.precedence_9,
2144: llt.precedence_10
2145: FROM jai_cmn_document_taxes llt,
2146: jai_cmn_lines cml,
2147: JAI_CMN_TAXES_ALL jtc ,
2148: jai_regime_tax_types_v tax_types
2149: WHERE cml.po_line_location_id = p_line_location_id
2150: AND cml.cmn_line_id = llt.source_doc_line_id

Line 2237: v_po_quantity := r_jai_cmn_lines.quantity;

2233: FROM po_line_locations_all
2234: WHERE line_location_id = p_line_location_id;
2235: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2236: THEN
2237: v_po_quantity := r_jai_cmn_lines.quantity;
2238: v_price_override := r_jai_cmn_lines.po_unit_price;
2239: ELSIF p_source_document_code = 'INVENTORY' THEN
2240: v_price_override := ln_item_cost; /* currently hard coded */
2241: v_po_quantity := ln_trx_qty; /* currently hard coded */

Line 2238: v_price_override := r_jai_cmn_lines.po_unit_price;

2234: WHERE line_location_id = p_line_location_id;
2235: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2236: THEN
2237: v_po_quantity := r_jai_cmn_lines.quantity;
2238: v_price_override := r_jai_cmn_lines.po_unit_price;
2239: ELSIF p_source_document_code = 'INVENTORY' THEN
2240: v_price_override := ln_item_cost; /* currently hard coded */
2241: v_po_quantity := ln_trx_qty; /* currently hard coded */
2242: END IF;

Line 2254: OPEN c_jai_cmn_lines(v_shipment_num);

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);
2255: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2256: CLOSE c_jai_cmn_lines;
2257:
2258: ln_po_unit_price := 0;

Line 2255: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;

2251: END IF;
2252:
2253:
2254: OPEN c_jai_cmn_lines(v_shipment_num);
2255: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2256: CLOSE c_jai_cmn_lines;
2257:
2258: ln_po_unit_price := 0;
2259: IF lv_asbn_type = 'TRUE'

Line 2256: CLOSE c_jai_cmn_lines;

2252:
2253:
2254: OPEN c_jai_cmn_lines(v_shipment_num);
2255: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2256: CLOSE c_jai_cmn_lines;
2257:
2258: ln_po_unit_price := 0;
2259: IF lv_asbn_type = 'TRUE'
2260: THEN

Line 2261: ln_po_unit_price := r_jai_cmn_lines.po_unit_price;

2257:
2258: ln_po_unit_price := 0;
2259: IF lv_asbn_type = 'TRUE'
2260: THEN
2261: ln_po_unit_price := r_jai_cmn_lines.po_unit_price;
2262: END IF ;
2263: If p_source_document_code <> 'INVENTORY' THEN /*rchandan - 6030615*/
2264: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value (
2265: p_party_id => p_vendor_id,

Line 2269: p_default_price => ln_po_unit_price * r_jai_cmn_lines.quantity,

2265: p_party_id => p_vendor_id,
2266: p_party_site_id => p_vendor_site_id,
2267: p_inventory_item_id => v_item_id,
2268: p_uom_code => p_uom_code,
2269: p_default_price => ln_po_unit_price * r_jai_cmn_lines.quantity,
2270: p_ass_value_date => trunc(sysdate) ,
2271: p_party_type => 'V'
2272: );
2273: IF ln_vat_assess_value=0