[Home] [Help]
19: )
20: IS
21:
22: /** author: brathod
23: Modified following cursor to refer ap_supplier_sites_all to retrieve supplier address.
24: Cursor was wrongly refering to hz_party_sites_all and hz_locations as
25: jg_zz_vat_trx_details.billing_tp_address_id (value passed in parameter p_party_site_id) is actually a
26: supplier_site_id and not party_site_id. Please refer bug#5031773
27: */
35: , assa.city CITY
36: , SUBSTR(assa.address_line1,1,35)||' '||
37: SUBSTR(assa.address_line2,1,35)||' '||
38: SUBSTR(assa.address_line3,1,35) ADDRESS_DETAIL
39: FROM ap_supplier_sites_all assa
40: , fnd_territories FT
41: WHERE assa.vendor_site_id = p_party_site_id
42: AND assa.country(+) = FT.territory_code;
43:
1301: */
1302: lc_jgzz_modelo_query :=
1303: REPLACE( lc_jgzz_modelo_query
1304: , '$MODELO_TABLE_LIST$'
1305: ,', AP_SUPPLIER_SITES_ALL APSS, AP_SUPPLIERS APS' );
1306:
1307: lc_jgzz_modelo_query :=
1308: REPLACE( lc_jgzz_modelo_query
1309: , '$ADDRESS_ID$'
1407: , ''415_347PR'',''Y'') PROPERTY_RENTAL
1408: FROM jg_zz_vat_rep_status JZVRS
1409: , jg_zz_vat_trx_details JZVTD
1410: , ap_suppliers aps
1411: , ap_supplier_sites_all apss
1412: /**
1413: author:brathod
1414: , ap_invoice_distributions_all AID
1415: , ap_invoice_distributions_all ALC
1525: */
1526: lc_jgzz_modelo_query :=
1527: REPLACE( lc_jgzz_modelo_query
1528: , '$MODELO_TABLE_LIST$'
1529: ,', AP_SUPPLIER_SITES_ALL APSS' );
1530:
1531:
1532: lc_jgzz_modelo_query :=
1533: REPLACE( lc_jgzz_modelo_query