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 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 627: jai_regime_tax_types_v aa

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
631: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN

Line 668: jai_regime_tax_types_v aa

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
672: ORDER BY 1;

Line 711: jai_regime_tax_types_v aa

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
715: ORDER BY 1;

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 2074: jai_regime_tax_types_v aa

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
2078: -- START ILIPROCUREMENT FORWARD PORTING - KVAIDYAN

Line 2107: jai_regime_tax_types_v aa,

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
2111: AND rsh.shipment_header_id = A.SHIPMENT_HEADER_ID --Added by Kevin Cheng

Line 2138: jai_regime_tax_types_v aa

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
2142: ORDER BY 1;

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 3795: jai_regime_tax_types_v aa

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
3799: AND aa.tax_type(+) = b.tax_type

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 3933: jai_regime_tax_types_v aa

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
3937: AND aa.tax_type(+) = b.tax_type