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_REGIME_TAX_TYPES_V

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

497: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
498: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
499: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
500: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
501: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
502: WHERE Po_Line_Id = p_line_id
503: AND Line_Location_Id = p_line_loc_id
504: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
505: AND A.Tax_Id = B.Tax_Id

Line 550: jai_regime_tax_types_v aa

546: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
547: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
548: FROM JAI_PO_REQ_LINE_TAXES A,
549: JAI_CMN_TAXES_ALL B,
550: jai_regime_tax_types_v aa
551: WHERE requisition_line_Id = p_line_id
552: AND A.Tax_Id = B.Tax_Id
553: AND aa.tax_type(+) = b.tax_type
554: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN

Line 586: jai_regime_tax_types_v aa

582: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
583: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
584: FROM jai_rcv_line_taxes A,
585: JAI_CMN_TAXES_ALL B,
586: jai_regime_tax_types_v aa
587: WHERE shipment_line_id = p_line_id /* shipment line id */
588: AND A.Tax_Id = B.Tax_Id
589: AND aa.tax_type(+) = b.tax_type
590: ORDER BY 1;

Line 624: jai_regime_tax_types_v aa

620: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
621: , B.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 18, 2007
622: FROM Jai_cmn_document_Taxes A,
623: JAI_CMN_TAXES_ALL B,
624: jai_regime_tax_types_v aa
625: WHERE source_doc_line_id = p_line_id /* source doc line id */
626: AND A.Tax_Id = B.Tax_Id
627: AND aa.tax_type(+) = b.tax_type
628: ORDER BY 1;

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

1348: A.Tax_Rate tax_rate, A.Qty_Rate Qty_Rate, A.uom uom_code,
1349: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1350: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1351: , pha.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1352: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B,jai_regime_tax_types_v aa
1353: , po_headers_all pha --Added by Kevin Cheng
1354: WHERE Po_Line_Id = p_line_id
1355: AND Line_Location_Id = p_line_loc_id
1356: --AND NVL( Line_Location_Id, -999 ) = p_line_loc_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 1395: jai_regime_tax_types_v aa

1391: A.Tax_Amount, A.currency curr, B.End_Date Valid_Date,
1392: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1393: FROM JAI_PO_REQ_LINE_TAXES A,
1394: JAI_CMN_TAXES_ALL B,
1395: jai_regime_tax_types_v aa
1396: WHERE requisition_line_Id = p_line_id
1397: AND A.Tax_Id = B.Tax_Id
1398: AND aa.tax_type(+) = b.tax_type
1399: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN

Line 1423: jai_regime_tax_types_v aa,

1419: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1420: , rsh.vendor_id hdr_vendor_id, A.Vendor_Id tax_vendor_id --Added by Kevin Cheng
1421: FROM jai_rcv_line_taxes A,
1422: JAI_CMN_TAXES_ALL B,
1423: jai_regime_tax_types_v aa,
1424: RCV_SHIPMENT_HEADERS rsh --Added by Kevin Cheng
1425: WHERE shipment_line_id = p_line_id /* shipment line id */
1426: AND A.Tax_Id = B.Tax_Id
1427: AND rsh.shipment_header_id = A.SHIPMENT_HEADER_ID --Added by Kevin Cheng

Line 1454: jai_regime_tax_types_v aa

1450: A.Tax_Amt tax_amount, A.currency_code curr, B.End_Date Valid_Date,
1451: B.rounding_factor rnd_factor, B.adhoc_flag adhoc_flag
1452: FROM Jai_cmn_document_Taxes A,
1453: JAI_CMN_TAXES_ALL B,
1454: jai_regime_tax_types_v aa
1455: WHERE source_doc_line_id = p_line_id \* source doc line id *\
1456: AND A.Tax_Id = B.Tax_Id
1457: AND aa.tax_type(+) = b.tax_type
1458: ORDER BY 1;

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

2887: ---------------------------------------------------
2888: 'TDS', 2, 0
2889: )
2890: ) tax_type_val
2891: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
2892: WHERE requisition_line_id = p_line_id
2893: AND a.Tax_Id = b.Tax_Id
2894: AND aa.tax_type(+) = b.tax_type
2895: order by 1/*2*/;--Modified by Kevin Cheng for inclusive tax Dec 17, 2007

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

2936: B.End_Date Valid_Date,
2937: B.rounding_factor rnd_factor,
2938: B.adhoc_flag adhoc_flag
2939: ,b.inclusive_tax_flag --Add by Kevin for inclusive tax Dec 17, 2007
2940: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
2941: WHERE Po_Line_Id = p_po_line_id
2942: --AND nvl(line_location_id,-999) = p_line_location_id
2943: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/
2944: AND A.Tax_Id = B.Tax_Id

Line 3018: jai_regime_tax_types_v aa

3014: B.adhoc_flag adhoc_flag
3015: , b.inclusive_tax_flag --Add by Kevin Cheng for inclusive tax Dec 17, 2007
3016: FROM Jai_cmn_document_Taxes A,
3017: JAI_CMN_TAXES_ALL B,
3018: jai_regime_tax_types_v aa
3019: WHERE source_doc_line_id = cp_source_doc_line_id
3020: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3021: AND A.Tax_Id = B.Tax_Id
3022: AND aa.tax_type(+) = b.tax_type

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

3054: 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,
3055: 'TDS', 2, 0
3056: )
3057: ) tax_type_val
3058: FROM JAI_PO_REQ_LINE_TAXES a, JAI_CMN_TAXES_ALL b, jai_regime_tax_types_v aa
3059: WHERE requisition_line_id = p_line_id
3060: AND a.Tax_Id = b.Tax_Id
3061: AND aa.tax_type(+) = b.tax_type
3062: order by 2;

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

3095: B.End_Date Valid_Date,
3096: B.rounding_factor rnd_factor,
3097: B.adhoc_flag adhoc_flag
3098: , pha.vendor_id hdr_vendor_id, a.vendor_id tax_vendor_id --Added by Kevin Cheng
3099: FROM JAI_PO_TAXES A, JAI_CMN_TAXES_ALL B, jai_regime_tax_types_v aa
3100: , po_headers_all pha --Added by Kevin Cheng
3101: WHERE Po_Line_Id = p_po_line_id
3102: --AND nvl(line_location_id,-999) = p_line_location_id
3103: AND line_location_id = p_line_location_id /* Modified by Ramananda for removal of SQL LITERALs :bug#4428980*/

Line 3143: jai_regime_tax_types_v aa

3139: B.rounding_factor rnd_factor,
3140: B.adhoc_flag adhoc_flag
3141: FROM Jai_cmn_document_Taxes A,
3142: JAI_CMN_TAXES_ALL B,
3143: jai_regime_tax_types_v aa
3144: WHERE source_doc_line_id = cp_source_doc_line_id
3145: AND source_doc_id = cp_source_doc_id --pramasub added this condn for bug #6137011
3146: AND A.Tax_Id = B.Tax_Id
3147: AND aa.tax_type(+) = b.tax_type