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_AP_DTC_GENERATION_PKG dependencies on JAI_AP_TDS_TH_VSITE_V

Line 1560: from JAI_AP_TDS_TH_VSITE_V

1556: p_section_type jai_ap_tds_inv_taxes.section_type%type
1557: )
1558: IS
1559: select threshold_hdr_id
1560: from JAI_AP_TDS_TH_VSITE_V
1561: where vendor_id = p_vendor_id
1562: and vendor_site_id = p_vendor_site_id
1563: and section_type = p_section_type --rchandan for bug#4428980
1564: and section_code = p_tds_section_code

Line 1578: from JAI_AP_TDS_TH_VSITE_V

1574: p_section_type jai_ap_tds_inv_taxes.section_type%type
1575: )
1576: IS
1577: select threshold_hdr_id
1578: from JAI_AP_TDS_TH_VSITE_V
1579: where vendor_id = p_vendor_id
1580: and vendor_site_id = p_vendor_site_id
1581: and section_type = p_section_type
1582: and section_code = p_tds_section_code

Line 1595: FROM JAI_AP_TDS_TH_VSITE_V JATVV

1591: cursor c_get_threshold_normal (cp_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
1592: cp_sec_code varchar2)
1593: is
1594: SELECT threshold_hdr_id
1595: FROM JAI_AP_TDS_TH_VSITE_V JATVV
1596: WHERE tds_vendor_type_lookup_code = cp_vendor_tlc
1597: AND section_code = cp_sec_code
1598: AND section_type = 'TDS_SECTION'
1599: AND nvl(exception_setup_flag,'N') = 'N'

Line 1645: --by given vendor and vendor site, if already existing exception transactions, will not show normal records in JAI_AP_TDS_TH_VSITE_V.

1641: if nvl(ln_threshold_hdr_id,0) = 0 then
1642:
1643: --Added commented by Chong for bug#16580553 20130402 Begin
1644: -------------------------------------------------------------
1645: --by given vendor and vendor site, if already existing exception transactions, will not show normal records in JAI_AP_TDS_TH_VSITE_V.
1646: --So we can't get noraml threshold setup by vendor and vendor site. we should derive normal threshold setup by vendor type
1647: open c_po_vendors(cn_vendor_id); --Added by Chong for bug#16580553 20130402
1648: fetch c_po_vendors into lv_vendor_type_lookup_code;
1649: close c_po_vendors;

Line 2465: from JAI_AP_TDS_TH_VSITE_V

2461:
2462: cursor c_get_threshold
2463: (p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2,p_section_type jai_ap_tds_inv_taxes.section_type%type) IS --rchandan for bug#4428980
2464: select threshold_hdr_id
2465: from JAI_AP_TDS_TH_VSITE_V
2466: where vendor_id = p_vendor_id
2467: and vendor_site_id = p_vendor_site_id
2468: and section_type = p_section_type --rchandan for bug#4428980
2469: and section_code = p_tds_section_code;

Line 2951: from JAI_AP_TDS_TH_VSITE_V

2947: p_section_type jai_ap_tds_inv_taxes.section_type%type
2948: )
2949: IS
2950: select threshold_hdr_id
2951: from JAI_AP_TDS_TH_VSITE_V
2952: where vendor_id = p_vendor_id
2953: and vendor_site_id = p_vendor_site_id
2954: and section_type = p_section_type --rchandan for bug#4428980
2955: and section_code = p_tds_section_code

Line 2979: from JAI_AP_TDS_TH_VSITE_V

2975: p_section_type jai_ap_tds_inv_taxes.section_type%type
2976: )
2977: IS
2978: select threshold_hdr_id
2979: from JAI_AP_TDS_TH_VSITE_V
2980: where vendor_id = p_vendor_id
2981: and vendor_site_id = p_vendor_site_id
2982: and section_type = p_section_type --rchandan for bug#4428980
2983: and section_code = p_tds_section_code

Line 2994: FROM JAI_AP_TDS_TH_VSITE_V JATVV

2990: cursor c_get_threshold_normal (cp_vendor_tlc JAI_AP_TDS_VENDOR_HDRS.TDS_VENDOR_TYPE_LOOKUP_CODE%TYPE,
2991: cp_sec_code varchar2)
2992: is
2993: SELECT threshold_hdr_id
2994: FROM JAI_AP_TDS_TH_VSITE_V JATVV
2995: WHERE tds_vendor_type_lookup_code = cp_vendor_tlc
2996: AND section_code = cp_sec_code
2997: AND section_type = 'TDS_SECTION'
2998: AND nvl(exception_setup_flag,'N') = 'N'

Line 3644: --by given vendor and vendor site, if already existing exception transactions, will not show normal records in JAI_AP_TDS_TH_VSITE_V.

3640: if nvl(ln_threshold_hdr_id,0) = 0 then
3641:
3642: --Added commented by Chong for bug#16580553 20130402 Begin
3643: -------------------------------------------------------------
3644: --by given vendor and vendor site, if already existing exception transactions, will not show normal records in JAI_AP_TDS_TH_VSITE_V.
3645: --So we can't get noraml threshold setup by vendor and vendor site. we should derive normal threshold setup by vendor type
3646: open c_po_vendors(p_vendor_id); --Added by Chong for bug#16580553 20130402
3647: fetch c_po_vendors into lv_vendor_type_lookup_code;
3648: close c_po_vendors;

Line 5188: from JAI_AP_TDS_TH_VSITE_V

5184: ln_tax_amount number;
5185:
5186: cursor c_get_threshold(p_vendor_id number, p_vendor_site_id number, p_tds_section_code varchar2) is
5187: select threshold_hdr_id
5188: from JAI_AP_TDS_TH_VSITE_V
5189: where vendor_id = p_vendor_id
5190: and vendor_site_id = p_vendor_site_id
5191: and section_type = 'TDS_SECTION'
5192: and section_code = p_tds_section_code;

Line 9062: FROM jai_ap_tds_th_vsite_v

9058: p_pan_num VARCHAR2,
9059: p_section_type VARCHAR2,
9060: p_section_code VARCHAR2) IS
9061: SELECT threshold_hdr_id
9062: FROM jai_ap_tds_th_vsite_v
9063: WHERE vendor_id = p_vendor_id
9064: AND tan_no = p_org_tan_num
9065: AND pan_no = p_pan_num
9066: AND section_type = p_section_type