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_PO_TAX_PKG dependencies on JAI_CMN_TAXES_ALL

Line 323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

319: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
327: );

Line 324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,

320: Uom_code JAI_PO_TAXES.UOM%TYPE,
321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
327: );
328:

Line 325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE

321: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
327: );
328:
329:

Line 326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007

322: Curr JAI_PO_TAXES.CURRENCY%TYPE,
323: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
324: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
325: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE
326: ,Inclusive_tax_flag JAI_CMN_TAXES_ALL.Inclusive_Tax_Flag%TYPE --Add by Kevin Cheng for inclusive tax Dec 18, 2007
327: );
328:
329:
330: -- START, Vijay Shankar for Bug# 3190782

Line 360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,

356: Qty_Rate JAI_PO_TAXES.QTY_RATE%TYPE,
357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE

Line 361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,

357: Uom_code JAI_PO_TAXES.UOM%TYPE,
358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
365: );

Line 362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,

358: Tax_Amount JAI_PO_TAXES.TAX_AMOUNT%TYPE,
359: Curr JAI_PO_TAXES.CURRENCY%TYPE,
360: Valid_Date JAI_CMN_TAXES_ALL.END_DATE%TYPE,
361: Rnd_factor JAI_CMN_TAXES_ALL.ROUNDING_FACTOR%TYPE,
362: Adhoc_flag JAI_CMN_TAXES_ALL.ADHOC_FLAG%TYPE,
363: hdr_vendor_id PO_HEADERS_ALL.Vendor_Id%TYPE,
364: tax_vendor_id JAI_PO_TAXES.Vendor_Id%TYPE
365: );
366:

Line 380: select A.tax_amount from JAI_PO_REQ_LINE_TAXES A, JAI_CMN_TAXES_ALL B

376: lv_process_message VARCHAR2(2000);
377: --=====================================================
378:
379: Cursor req_adhoc_tax_amt(taxid number) is
380: select A.tax_amount from JAI_PO_REQ_LINE_TAXES A, JAI_CMN_TAXES_ALL B
381: where A.tax_id = taxid
382: AND requisition_line_id in(select requisition_line_id
383: from po_req_distributions_all
384: where distribution_id in (select req_distribution_id

Line 396: FROM jai_cmn_taxes_all

392: v_adhoc_flag varchar2(1);
393: --start additions by vkaranam for bug#14632514
394: CURSOR c_tax_details(a_tax_id number) IS
395: SELECT vat_flag
396: FROM jai_cmn_taxes_all
397: WHERE Tax_id = a_tax_id;
398: v_vat_flag varchar2(1);
399: v_qty_rate number;
400: -- end of cursor added by subbu on 8-nov-01

Line 573: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa

569: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
570: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
571: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
572: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
573: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
574: WHERE Po_Line_Id = p_line_id
575: AND Line_Location_Id = p_line_loc_id
576: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
577: AND A.Tax_Id = B.Tax_Id

Line 626: JAI_CMN_TAXES_ALL B,

622: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
623: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
624: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
625: FROM JAI_PO_REQ_LINE_TAXES A,
626: JAI_CMN_TAXES_ALL B,
627: jai_regime_tax_types_v aa
628: WHERE requisition_line_Id = p_line_id
629: AND A.Tax_Id = B.Tax_Id
630: AND aa.tax_type(+) = b.tax_type

Line 667: JAI_CMN_TAXES_ALL B,

663: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
664: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
665: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
666: FROM jai_rcv_line_taxes A,
667: JAI_CMN_TAXES_ALL B,
668: jai_regime_tax_types_v aa
669: WHERE shipment_line_id = p_line_id /* shipment line id */
670: AND A.Tax_Id = B.Tax_Id
671: AND aa.tax_type(+) = b.tax_type

Line 710: JAI_CMN_TAXES_ALL B,

706: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
707: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
708: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
709: FROM Jai_cmn_document_Taxes A,
710: JAI_CMN_TAXES_ALL B,
711: jai_regime_tax_types_v aa
712: WHERE source_doc_line_id = p_line_id /* source doc line id */
713: AND A.Tax_Id = B.Tax_Id
714: AND aa.tax_type(+) = b.tax_type

Line 2031: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa

2027: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2028: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2029: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2030: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
2031: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
2032: , po_headers_all pha --Added by Kevin Cheng
2033: WHERE Po_Line_Id = p_line_id
2034: AND Line_Location_Id = p_line_loc_id
2035: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 2073: JAI_CMN_TAXES_ALL B,

2069: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2070: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2071: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2072: FROM JAI_PO_REQ_LINE_TAXES A,
2073: JAI_CMN_TAXES_ALL B,
2074: jai_regime_tax_types_v aa
2075: WHERE requisition_line_Id = p_line_id
2076: AND A.Tax_Id = B.Tax_Id
2077: AND aa.tax_type(+) = b.tax_type

Line 2106: JAI_CMN_TAXES_ALL B,

2102: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
2103: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2104: , rsh.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
2105: FROM jai_rcv_line_taxes A,
2106: JAI_CMN_TAXES_ALL B,
2107: jai_regime_tax_types_v aa,
2108: RCV_SHIPMENT_HEADERS rsh --Added by Kevin Cheng
2109: WHERE shipment_line_id = p_line_id /* shipment line id */
2110: AND A.Tax_Id = B.Tax_Id

Line 2137: JAI_CMN_TAXES_ALL B,

2133: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
2134: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
2135: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
2136: FROM Jai_cmn_document_Taxes A,
2137: JAI_CMN_TAXES_ALL B,
2138: jai_regime_tax_types_v aa
2139: WHERE source_doc_line_id = p_line_id \* source doc line id *\
2140: AND A.Tax_Id = B.Tax_Id
2141: AND aa.tax_type(+) = b.tax_type

Line 3659: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa

3655: ---------------------------------------------------
3656: 'TDS', 2, 0
3657: )
3658: ) tax_type_val
3659: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3660: WHERE requisition_line_id = p_line_id
3661: AND a.Tax_Id = b.Tax_Id
3662: AND aa.tax_type(+) = b.tax_type
3663: order by 1/*2*/;--Modified by Kevin Cheng for inclusive tax Dec 17, 2007

Line 3712: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa

3708: B.End_Date Valid_Date,
3709: B.rounding_factor rnd_factor,
3710: B.adhoc_flag adhoc_flag
3711: ,b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 17, 2007
3712: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3713: WHERE Po_Line_Id = p_po_line_id
3714: AND nvl(line_location_id,-999) = p_line_location_id /*uncommented for bug 9307152, commented line below*/
3715: --AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
3716: AND A.Tax_Id = B.Tax_Id

Line 3794: JAI_CMN_TAXES_ALL B,

3790: B.rounding_factor rnd_factor,
3791: B.adhoc_flag adhoc_flag
3792: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3793: FROM Jai_cmn_document_Taxes A,
3794: JAI_CMN_TAXES_ALL B,
3795: jai_regime_tax_types_v aa
3796: WHERE source_doc_line_id = cp_source_doc_line_id
3797: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3798: AND A.Tax_Id = B.Tax_Id

Line 3839: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa

3835: JAI_CONSTANTS.TAX_TYPE_SH_EXC_EDU_CESS,1,jai_constants.tax_type_exc_edu_cess, 1, --,jai_constants.tax_type_cvd_edu_cess, 1,
3836: 'TDS', 2, 0
3837: )
3838: ) tax_type_val
3839: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3840: WHERE requisition_line_id = p_line_id
3841: AND a.Tax_Id = b.Tax_Id
3842: AND aa.tax_type(+) = b.tax_type
3843: order by 2;

Line 3884: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa

3880: B.End_Date Valid_Date,
3881: B.rounding_factor rnd_factor,
3882: B.adhoc_flag adhoc_flag
3883: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3884: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3885: , po_headers_all pha --Added by Kevin Cheng
3886: WHERE Po_Line_Id = p_po_line_id
3887: --AND nvl(line_location_id,-999) = p_line_location_id
3888: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 3932: JAI_CMN_TAXES_ALL B,

3928: B.End_Date Valid_Date,
3929: B.rounding_factor rnd_factor,
3930: B.adhoc_flag adhoc_flag
3931: FROM Jai_cmn_document_Taxes A,
3932: JAI_CMN_TAXES_ALL B,
3933: jai_regime_tax_types_v aa
3934: WHERE source_doc_line_id = cp_source_doc_line_id
3935: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3936: AND A.Tax_Id = B.Tax_Id

Line 6934: from JAI_CMN_TAXES_ALL

6930:
6931: --Added by Nagaraj.s for Bug2953445..
6932: CURSOR c_check_adhoc_flag(p_tax_id number) IS
6933: select nvl(adhoc_flag,'N')
6934: from JAI_CMN_TAXES_ALL
6935: where tax_id = p_tax_id;
6936:
6937: --Added by Ravi for vat assessable vlue
6938: CURSOR cur_vendor

Line 6953: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --Nagaraj.s for Bug2953445.

6949:
6950: lv_item_id po_lines_all.item_id%type;
6951:
6952: vendor_rec cur_vendor%ROWTYPE;
6953: v_check_adhoc_flag JAI_CMN_TAXES_ALL.adhoc_flag%type; --Nagaraj.s for Bug2953445.
6954: v_tax_amount NUMBER;--Nagaraj.s for Bug2953445.
6955:
6956: ------------------------------>
6957:

Line 8210: FROM JAI_CMN_TAXES_ALL

8206: ORDER BY Tax_Line_No;
8207:
8208: CURSOR Fetch_Mod_Cr_Cur( taxid IN NUMBER ) IS
8209: SELECT Tax_Type, Mod_Cr_Percentage, Vendor_Id,adhoc_flag --kundan kumar for forward porting to R12
8210: FROM JAI_CMN_TAXES_ALL
8211: WHERE Tax_Id = taxid;
8212:
8213: CURSOR Fetch_Sum_Cur( Lfid IN NUMBER ) IS
8214: SELECT SUM( NVL( Tax_Amount, 0 ) )

Line 9042: FROM JAI_CMN_TAXES_ALL

9038: v_tax_target NUMBER;
9039: --Start Added by kundan kumar for forward porting to R12
9040: CURSOR cur_taxes_adhoc(cp_tax_id number) IS --rchandan for bug#4591242
9041: SELECT adhoc_flag
9042: FROM JAI_CMN_TAXES_ALL
9043: WHERE tax_id = cp_tax_id;
9044:
9045: lv_adhoc_flag varchar2(1); --rchandan for bug#4591242
9046: --End kundan kumar