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.ZX_PTP_MIGRATE_PKG dependencies on AP_SUPPLIER_SITES_ALL

Line 1742: ap_supplier_sites_all PVS

1738: , rank() OVER(PARTITION BY PVS.PARTY_SITE_ID ORDER BY PVS.VENDOR_SITE_ID ) COUNT
1739:
1740: FROM
1741: ap_suppliers PV,
1742: ap_supplier_sites_all PVS
1743: WHERE
1744: PVS.VENDOR_SITE_ID = nvl(p_party_id,PVS.VENDOR_SITE_ID) --this condition is for the sync process
1745: AND PV.VENDOR_ID = PVS.VENDOR_ID
1746: AND NOT EXISTS

Line 1848: ap_supplier_sites_all pvs,

1844: ,counter
1845:
1846: FROM
1847: ap_suppliers pv,
1848: ap_supplier_sites_all pvs,
1849: zx_party_tax_profile PTP,
1850: (select party_site_id,
1851: COUNT
1852: (DISTINCT(PARTY_SITE_ID||AMOUNT_INCLUDES_TAX_FLAG

Line 1855: ap_supplier_sites_all

1851: COUNT
1852: (DISTINCT(PARTY_SITE_ID||AMOUNT_INCLUDES_TAX_FLAG
1853: ||AP_TAX_ROUNDING_RULE||AUTO_TAX_CALC_FLAG||OFFSET_TAX_FLAG||VAT_CODE||VAT_REGISTRATION_NUM) ) Counter
1854: FROM
1855: ap_supplier_sites_all
1856: group by party_site_id
1857: ) tax_attr_tab
1858: WHERE
1859: pv.vendor_id = pvs.vendor_id

Line 1926: FROM ap_supplier_sites_all Pvs,

1922: ,fnd_global.user_id -- Who Columns
1923: ,SYSDATE -- Who Columns
1924: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1925: ,1
1926: FROM ap_supplier_sites_all Pvs,
1927: ap_suppliers Pv
1928: WHERE pvs.Vendor_Site_Id = nvl(P_Party_Id,pvs.Vendor_site_Id)
1929: AND pvs.vendor_id = pv.vendor_id
1930: AND not exists ( select 1 from zx_party_tax_profile

Line 1993: FROM ap_supplier_sites_all PVS,

1989: ,fnd_global.user_id
1990: ,SYSDATE
1991: ,FND_GLOBAL.CONC_LOGIN_ID
1992: ,1
1993: FROM ap_supplier_sites_all PVS,
1994: ap_suppliers PV,
1995: zx_party_tax_profile PTP
1996: WHERE
1997: PVS.vendor_site_id = PTP.Party_ID

Line 2087: FROM ap_supplier_sites_all PVS,

2083: ,fnd_global.user_id
2084: ,SYSDATE
2085: ,FND_GLOBAL.CONC_LOGIN_ID
2086: ,1
2087: FROM ap_supplier_sites_all PVS,
2088: ap_suppliers PV,
2089: zx_party_tax_profile PTP
2090: WHERE
2091: PVS.vendor_site_id = PTP.Party_ID

Line 2161: FROM ap_supplier_sites_all PVS,

2157: ,fnd_global.user_id
2158: ,SYSDATE
2159: ,FND_GLOBAL.CONC_LOGIN_ID
2160: ,1
2161: FROM ap_supplier_sites_all PVS,
2162: ap_suppliers PV,
2163: zx_party_tax_profile PTP
2164: WHERE
2165: PVS.vendor_site_id = PTP.Party_ID

Line 2235: FROM ap_supplier_sites_all PVS,

2231: ,fnd_global.user_id
2232: ,SYSDATE
2233: ,FND_GLOBAL.CONC_LOGIN_ID
2234: ,1
2235: FROM ap_supplier_sites_all PVS,
2236: ap_suppliers PV,
2237: zx_party_tax_profile PTP
2238: WHERE
2239: PVS.vendor_site_id = PTP.Party_ID