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_TAXES_ALL

Line 101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;

97: v_register_type JAI_CMN_RG_23AC_I_TRXS.register_type % TYPE;
98: v_duplicate_ship VARCHAR2(1); --File.Sql.35 Cbabu := 'N';
99: v_picking_line_id JAI_OM_WSH_LINES_ALL.delivery_detail_id % TYPE; --added
100: v_rsh_organization_id rcv_shipment_headers.organization_id % TYPE;
101: v_internal_vendor JAI_CMN_TAXES_ALL.vendor_id % TYPE;
102: v_current_tax NUMBER;
103: v_trading JAI_CMN_INVENTORY_ORGS.trading % TYPE;
104: v_manufacturing JAI_CMN_INVENTORY_ORGS.manufacturing % TYPE;
105: v_bonded JAI_INV_SUBINV_DTLS.bonded % TYPE;

Line 230: from jai_cmn_taxes_all

226: is
227: select NVL(inclusive_tax_flag,'N'),
228: end_date,
229: NVL(adhoc_flag,'N')--Added by qiong.liu for bug12717416 2011.07.06
230: from jai_cmn_taxes_all
231: where tax_id=pn_tax_id;
232: -----------------------------------------------
233:
234: CURSOR c_rgm_setup_for_orgn_loc(cp_regime_code varchar2, cp_organization_type varchar2,

Line 406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,

402: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
403: Uom JAI_PO_TAXES.UOM%TYPE,
404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,

Line 408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

404: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,

Line 409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

405: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,

Line 410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,

406: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
407: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

Line 412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,

408: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

Line 413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,

409: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
410: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
411: currency JAI_PO_TAXES.currency%type,
412: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
413: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
414: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
415: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
416: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
417: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 519: FROM jai_cmn_taxes_all

515: --commented by qiong.liu for bug12717416 2011.07.06 begin
516: ---------------------------------------------------------
517: /* CURSOR get_adhoc_flag(pn_tax_id NUMBER) IS
518: SELECT adhoc_flag
519: FROM jai_cmn_taxes_all
520: WHERE tax_id = pn_tax_id;
521:
522: lv_adhoc_flag VARCHAR2(1);*/
523: --------------------------------------------------------

Line 647: JAI_CMN_TAXES_ALL jtc

643: rtl.tax_type,
644: rtl.tax_line_no,
645: jtc.rounding_factor
646: FROM JAI_RCV_LINE_TAXES rtl,
647: JAI_CMN_TAXES_ALL jtc
648: WHERE rtl.shipment_line_id = p_shipment_line_id
649: AND jtc.tax_id = rtl.tax_id)
650: LOOP
651: v_current_tax := ROUND((lines_rec.tax_amount * v_cor_quantity),

Line 2095: JAI_CMN_TAXES_ALL jtc

2091: rtl.precedence_10,
2092: tax_types.regime_code regime_code
2093: --3848133
2094: FROM JAI_OM_OE_RMA_TAXES rtl,
2095: JAI_CMN_TAXES_ALL jtc
2096: , jai_regime_tax_types_v tax_types
2097: WHERE rtl.rma_line_id = p_oe_order_line_id
2098: AND jtc.tax_id = rtl.tax_id
2099: AND tax_types.tax_type(+) = jtc.tax_type

Line 2345: JAI_CMN_TAXES_ALL jtc

2341: llt.precedence_8,
2342: llt.precedence_9,
2343: llt.precedence_10
2344: FROM JAI_PO_TAXES llt,
2345: JAI_CMN_TAXES_ALL jtc
2346: , jai_regime_tax_types_v tax_types
2347: WHERE line_location_id = p_line_location_id
2348: AND jtc.tax_id = llt.tax_id
2349: AND jtc.tax_type = tax_types.tax_type (+)

Line 2401: JAI_CMN_TAXES_ALL jtc ,

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
2405: AND cml.shipment_number = lv_shipment_num

Line 2471: JAI_CMN_TAXES_ALL jtc ,

2467: llt.precedence_8,
2468: llt.precedence_9,
2469: llt.precedence_10
2470: FROM jai_cmn_document_taxes llt,
2471: JAI_CMN_TAXES_ALL jtc ,
2472: jai_regime_tax_types_v tax_types,
2473: mtl_material_transactions mtl
2474: WHERE llt.source_doc_line_id = mtl.original_transaction_temp_id
2475: AND llt.source_doc_type = 'INTERORG_XFER'

Line 4287: JAI_CMN_TAXES_ALL jtc,

4283: stl.precedence_10,
4284: tax_types.regime_code regime_code
4285: --3848133
4286: FROM JAI_OM_WSH_LINE_TAXES stl,
4287: JAI_CMN_TAXES_ALL jtc,
4288: jai_regime_tax_types_v tax_types
4289: WHERE delivery_detail_id = v_picking_line_id --added by GSri and Jagdish on 5-may-01
4290: AND jtc.tax_id = stl.tax_id
4291: AND tax_types.tax_type(+) = jtc.tax_type

Line 4481: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types

4477: RTV creation should have taken care of this check
4478: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
4479: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
4480: , nvl(tax_types.regime_code, 'XXXX') regime_code
4481: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
4482: WHERE shipment_line_id = p_shipment_line_id
4483: AND NVL(modvat_flag, 'N') = 'Y'
4484: AND jtc.tax_type = tax_types.tax_type(+)
4485: AND jrtl.tax_id = jtc.tax_id)