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.

[Home] [Help]

APPS.JAI_RCV_TAX_PKG dependencies on JAI_CMN_LINES

Line 458: cursor c_jai_cmn_lines(cp_shipment_num VARCHAR2) IS

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

Line 460: FROM jai_cmn_lines

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
461: WHERE po_line_location_id = p_line_location_id
462: AND shipment_number = cp_shipment_num;
463:
464: r_jai_cmn_lines c_jai_cmn_lines%rowtype;

Line 464: r_jai_cmn_lines c_jai_cmn_lines%rowtype;

460: FROM jai_cmn_lines
461: WHERE po_line_location_id = p_line_location_id
462: AND shipment_number = cp_shipment_num;
463:
464: r_jai_cmn_lines c_jai_cmn_lines%rowtype;
465:
466: ln_trx_qty number;
467: lv_trx_uom varchar2(20);
468: ln_orig_id number;

Line 479: JAI_CMN_LINES

475: (
476: SELECT
477: EXCISE_INV_NUMBER
478: FROM
479: JAI_CMN_LINES
480: WHERE
481: HEADER_INTERFACE_ID = RHI.HEADER_INTERFACE_ID
482: AND rownum = 1
483: )

Line 489: JAI_CMN_LINES

485: (
486: SELECT
487: EXCISE_INV_DATE
488: FROM
489: JAI_CMN_LINES
490: WHERE
491: HEADER_INTERFACE_ID = RHI.HEADER_INTERFACE_ID
492: AND rownum = 1
493: )

Line 1379: excise_inv_num to excise_inv_number in jai_cmn_lines table

1375:
1376: Dependency Due to this Bug : Yes.
1377: 51. 16-07-2007 iSuppleir forward porting
1378: Changed shipment_num to shipment_number
1379: excise_inv_num to excise_inv_number in jai_cmn_lines table
1380:
1381: 52. 01-08-2007 rchandan for bug#6030615 , Version 120.17
1382: Issue : Inter org Forward porting
1383:

Line 2361: OPEN c_jai_cmn_lines(v_shipment_num);

2357: ja_in_Receipt_lines procedure in case of an asbn receipt.
2358: */
2359:
2360:
2361: OPEN c_jai_cmn_lines(v_shipment_num);
2362: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2363: CLOSE c_jai_cmn_lines;
2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;

Line 2362: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;

2358: */
2359:
2360:
2361: OPEN c_jai_cmn_lines(v_shipment_num);
2362: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2363: CLOSE c_jai_cmn_lines;
2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:

Line 2363: CLOSE c_jai_cmn_lines;

2359:
2360:
2361: OPEN c_jai_cmn_lines(v_shipment_num);
2362: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2363: CLOSE c_jai_cmn_lines;
2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:
2367: update JAI_RCV_LINES

Line 2365: v_loc_quantity := r_jai_cmn_lines.quantity;

2361: OPEN c_jai_cmn_lines(v_shipment_num);
2362: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2363: CLOSE c_jai_cmn_lines;
2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:
2367: update JAI_RCV_LINES
2368: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2369: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date

Line 2368: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,

2364:
2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:
2367: update JAI_RCV_LINES
2368: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2369: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date
2370: where shipment_line_id = p_shipment_line_id;
2371:
2372: OPEN c_po_tax_cur FOR

Line 2369: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date

2365: v_loc_quantity := r_jai_cmn_lines.quantity;
2366:
2367: update JAI_RCV_LINES
2368: set excise_invoice_no = r_jai_cmn_lines.excise_inv_number,
2369: excise_invoice_date=r_jai_cmn_lines.excise_inv_Date
2370: where shipment_line_id = p_shipment_line_id;
2371:
2372: OPEN c_po_tax_cur FOR
2373: SELECT tax_line_no,

Line 2400: jai_cmn_lines cml,

2396: llt.precedence_8,
2397: llt.precedence_9,
2398: llt.precedence_10
2399: FROM jai_cmn_document_taxes llt,
2400: jai_cmn_lines cml,
2401: JAI_CMN_TAXES_ALL jtc ,
2402: jai_regime_tax_types_v tax_types
2403: WHERE cml.po_line_location_id = p_line_location_id
2404: AND cml.cmn_line_id = llt.source_doc_line_id

Line 2491: v_po_quantity := r_jai_cmn_lines.quantity;

2487: FROM po_line_locations_all
2488: WHERE line_location_id = p_line_location_id;
2489: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2490: THEN
2491: v_po_quantity := r_jai_cmn_lines.quantity;
2492: v_price_override := r_jai_cmn_lines.po_unit_price;
2493: ELSIF p_source_document_code = 'INVENTORY' THEN
2494: v_price_override := ln_item_cost; /* currently hard coded */
2495: v_po_quantity := ln_trx_qty; /* currently hard coded */

Line 2492: v_price_override := r_jai_cmn_lines.po_unit_price;

2488: WHERE line_location_id = p_line_location_id;
2489: ELSIF p_source_document_code = 'PO' AND lv_asbn_type = 'TRUE'
2490: THEN
2491: v_po_quantity := r_jai_cmn_lines.quantity;
2492: v_price_override := r_jai_cmn_lines.po_unit_price;
2493: ELSIF p_source_document_code = 'INVENTORY' THEN
2494: v_price_override := ln_item_cost; /* currently hard coded */
2495: v_po_quantity := ln_trx_qty; /* currently hard coded */
2496: END IF;

Line 2545: OPEN c_jai_cmn_lines(v_shipment_num);

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);
2546: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2547: CLOSE c_jai_cmn_lines;
2548:
2549: ln_po_unit_price := 0;

Line 2546: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;

2542: END IF;
2543:
2544:
2545: OPEN c_jai_cmn_lines(v_shipment_num);
2546: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2547: CLOSE c_jai_cmn_lines;
2548:
2549: ln_po_unit_price := 0;
2550: IF lv_asbn_type = 'TRUE'

Line 2547: CLOSE c_jai_cmn_lines;

2543:
2544:
2545: OPEN c_jai_cmn_lines(v_shipment_num);
2546: FETCH c_jai_cmn_lines INTO r_jai_cmn_lines;
2547: CLOSE c_jai_cmn_lines;
2548:
2549: ln_po_unit_price := 0;
2550: IF lv_asbn_type = 'TRUE'
2551: THEN

Line 2552: ln_po_unit_price := r_jai_cmn_lines.po_unit_price;

2548:
2549: ln_po_unit_price := 0;
2550: IF lv_asbn_type = 'TRUE'
2551: THEN
2552: ln_po_unit_price := r_jai_cmn_lines.po_unit_price;
2553: END IF ;
2554: If p_source_document_code <> 'INVENTORY' THEN /*rchandan - 6030615*/
2555: ln_vat_assess_value := jai_general_pkg.ja_in_vat_assessable_value (
2556: p_party_id => p_vendor_id,

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

2556: p_party_id => p_vendor_id,
2557: p_party_site_id => p_vendor_site_id,
2558: p_inventory_item_id => v_item_id,
2559: p_uom_code => p_uom_code,
2560: p_default_price => ln_po_unit_price * r_jai_cmn_lines.quantity,
2561: p_ass_value_date => trunc(sysdate) ,
2562: p_party_type => 'V'
2563: );
2564: IF ln_vat_assess_value=0

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

2580: p_party_id => p_vendor_id,
2581: p_party_site_id => p_vendor_site_id,
2582: p_inventory_item_id => v_item_id,
2583: p_uom_code => p_uom_code,
2584: p_default_price => ln_po_unit_price * r_jai_cmn_lines.quantity,
2585: p_ass_value_date => trunc(SYSDATE) ,
2586: p_party_type => 'V'
2587: );
2588: IF ln_gst_assess_value=0