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 208: from jai_cmn_taxes_all

204: ( pn_tax_id number
205: )
206: is
207: select NVL(inclusive_tax_flag,'N'), end_date
208: from jai_cmn_taxes_all
209: where tax_id=pn_tax_id;
210: -----------------------------------------------
211:
212: CURSOR c_rgm_setup_for_orgn_loc(cp_regime_code varchar2, cp_organization_type varchar2,

Line 384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,

380: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
381: Uom JAI_PO_TAXES.UOM%TYPE,
382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,

Line 386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

382: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,

Line 387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,

383: tax_type JAI_PO_TAXES.TAX_TYPE%TYPE,
384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,

Line 388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,

384: tax_name JAI_CMN_TAXES_ALL.TAX_NAME%TYPE,
385: modvat_flag JAI_PO_TAXES.modvat_flag%TYPE,
386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,

Line 390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,

386: vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,

Line 391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,

387: tax_vendor_id JAI_CMN_TAXES_ALL.vendor_id%type,
388: vendor_site_id JAI_CMN_TAXES_ALL.vendor_site_id%type,
389: currency JAI_PO_TAXES.currency%type,
390: rounding_factor JAI_CMN_TAXES_ALL.rounding_factor%type,
391: duty JAI_CMN_TAXES_ALL.duty_drawback_percentage%type,
392: Precedence_1 JAI_PO_TAXES.PRECEDENCE_1%TYPE,
393: Precedence_2 JAI_PO_TAXES.PRECEDENCE_2%TYPE,
394: Precedence_3 JAI_PO_TAXES.PRECEDENCE_3%TYPE,
395: Precedence_4 JAI_PO_TAXES.PRECEDENCE_4%TYPE,

Line 570: JAI_CMN_TAXES_ALL jtc

566: rtl.tax_type,
567: rtl.tax_line_no,
568: jtc.rounding_factor
569: FROM JAI_RCV_LINE_TAXES rtl,
570: JAI_CMN_TAXES_ALL jtc
571: WHERE rtl.shipment_line_id = p_shipment_line_id
572: AND jtc.tax_id = rtl.tax_id)
573: LOOP
574: v_current_tax := ROUND((lines_rec.tax_amount * v_cor_quantity),

Line 1849: JAI_CMN_TAXES_ALL jtc

1845: rtl.precedence_10,
1846: tax_types.regime_code regime_code
1847: --3848133
1848: FROM JAI_OM_OE_RMA_TAXES rtl,
1849: JAI_CMN_TAXES_ALL jtc
1850: , jai_regime_tax_types_v tax_types
1851: WHERE rtl.rma_line_id = p_oe_order_line_id
1852: AND jtc.tax_id = rtl.tax_id
1853: AND tax_types.tax_type(+) = jtc.tax_type

Line 2091: JAI_CMN_TAXES_ALL jtc

2087: llt.precedence_8,
2088: llt.precedence_9,
2089: llt.precedence_10
2090: FROM JAI_PO_TAXES llt,
2091: JAI_CMN_TAXES_ALL jtc
2092: , jai_regime_tax_types_v tax_types
2093: WHERE line_location_id = p_line_location_id
2094: AND jtc.tax_id = llt.tax_id
2095: AND jtc.tax_type = tax_types.tax_type (+)

Line 2147: JAI_CMN_TAXES_ALL jtc ,

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

Line 2217: JAI_CMN_TAXES_ALL jtc ,

2213: llt.precedence_8,
2214: llt.precedence_9,
2215: llt.precedence_10
2216: FROM jai_cmn_document_taxes llt,
2217: JAI_CMN_TAXES_ALL jtc ,
2218: jai_regime_tax_types_v tax_types,
2219: mtl_material_transactions mtl
2220: WHERE llt.source_doc_line_id = mtl.original_transaction_temp_id
2221: AND llt.source_doc_type = 'INTERORG_XFER'

Line 3153: JAI_CMN_TAXES_ALL jtc,

3149: stl.precedence_10,
3150: tax_types.regime_code regime_code
3151: --3848133
3152: FROM JAI_OM_WSH_LINE_TAXES stl,
3153: JAI_CMN_TAXES_ALL jtc,
3154: jai_regime_tax_types_v tax_types
3155: WHERE delivery_detail_id = v_picking_line_id --added by GSri and Jagdish on 5-may-01
3156: AND jtc.tax_id = stl.tax_id
3157: AND tax_types.tax_type(+) = jtc.tax_type

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

3343: RTV creation should have taken care of this check
3344: Vijay Shankar for Bug#3940588. RECEIPTS DEPLUG */
3345: FOR exc_rec IN (SELECT jrtl.tax_amount, jrtl.tax_type tax_type, nvl(mod_cr_percentage, 0) mod_cr_percentage
3346: , nvl(tax_types.regime_code, 'XXXX') regime_code
3347: FROM JAI_RCV_LINE_TAXES jrtl, JAI_CMN_TAXES_ALL jtc, jai_regime_tax_types_v tax_types
3348: WHERE shipment_line_id = p_shipment_line_id
3349: AND NVL(modvat_flag, 'N') = 'Y'
3350: AND jtc.tax_type = tax_types.tax_type(+)
3351: AND jrtl.tax_id = jtc.tax_id)