[Home] [Help]
25: functionality onto AP invoice.
26:
27: 2. 2/05/2005 rchandan for bug#4323338. Version 116.0
28: India Org Info DFF is eliminated as a part of JA migration. A table by name ja_in_ap_tds_org_tan is dropped
29: and a view jai_ap_tds_org_tan_v is created to capture the PAN No,TAN NO and WARD NO. The code changes are done
30: to refer to the new view instead of the dropped table.
31:
32:
33: 3. 08-Jun-2005 Version 116.1 jai_ap_tds_dflt -Object is Modified to refer to New DB Entity names in place of Old DB Entity Names
1159: d.org_tan_num tan_no
1160: from po_vendors a,
1161: po_vendor_sites_all b,
1162: jai_ap_tds_vendor_hdrs c,
1163: jai_ap_tds_org_tan_v d --- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1164: where a.vendor_id = b.vendor_id
1165: and b.vendor_id = c.vendor_id
1166: and b.vendor_site_id = c.vendor_site_id
1167: and b.org_id = d.organization_id
1183: r_jai_ap_tds_thhold_slabs c_jai_ap_tds_thhold_slabs%rowtype;
1184: r_jai_ap_tds_thhold_taxes c_jai_ap_tds_thhold_taxes%rowtype;
1185:
1186: lv_pan_no jai_ap_tds_vendor_hdrs.pan_no%type;
1187: lv_tan_no jai_ap_tds_org_tan_v.org_tan_num %type;--- JAI_AP_TDS_ORG_TANS is changed to view jai_ap_tds_org_tan_v 4323338
1188:
1189:
1190: ln_total_invoice_amount number;
1191: ln_amount_for_redefault number;