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 1622: ap_supplier_sites_all PVS

1618: , rank() OVER(PARTITION BY PVS.PARTY_SITE_ID ORDER BY PVS.VENDOR_SITE_ID ) COUNT
1619:
1620: FROM
1621: ap_suppliers PV,
1622: ap_supplier_sites_all PVS
1623: WHERE
1624: PVS.VENDOR_SITE_ID = nvl(p_party_id,PVS.VENDOR_SITE_ID) --this condition is for the sync process
1625: AND PV.VENDOR_ID = PVS.VENDOR_ID
1626: AND NOT EXISTS

Line 1728: ap_supplier_sites_all pvs,

1724: ,counter
1725:
1726: FROM
1727: ap_suppliers pv,
1728: ap_supplier_sites_all pvs,
1729: zx_party_tax_profile PTP,
1730: (select party_site_id,
1731: COUNT
1732: (DISTINCT(PARTY_SITE_ID||AMOUNT_INCLUDES_TAX_FLAG

Line 1735: ap_supplier_sites_all

1731: COUNT
1732: (DISTINCT(PARTY_SITE_ID||AMOUNT_INCLUDES_TAX_FLAG
1733: ||AP_TAX_ROUNDING_RULE||AUTO_TAX_CALC_FLAG||OFFSET_TAX_FLAG||VAT_CODE||VAT_REGISTRATION_NUM) ) Counter
1734: FROM
1735: ap_supplier_sites_all
1736: group by party_site_id
1737: ) tax_attr_tab
1738: WHERE
1739: pv.vendor_id = pvs.vendor_id

Line 1806: FROM ap_supplier_sites_all Pvs,

1802: ,fnd_global.user_id -- Who Columns
1803: ,SYSDATE -- Who Columns
1804: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1805: ,1
1806: FROM ap_supplier_sites_all Pvs,
1807: ap_suppliers Pv
1808: WHERE pvs.Vendor_Site_Id = nvl(P_Party_Id,pvs.Vendor_site_Id)
1809: AND pvs.vendor_id = pv.vendor_id
1810: AND not exists ( select 1 from zx_party_tax_profile

Line 1873: FROM ap_supplier_sites_all PVS,

1869: ,fnd_global.user_id
1870: ,SYSDATE
1871: ,FND_GLOBAL.CONC_LOGIN_ID
1872: ,1
1873: FROM ap_supplier_sites_all PVS,
1874: ap_suppliers PV,
1875: zx_party_tax_profile PTP
1876: WHERE
1877: PVS.vendor_site_id = PTP.Party_ID

Line 1967: FROM ap_supplier_sites_all PVS,

1963: ,fnd_global.user_id
1964: ,SYSDATE
1965: ,FND_GLOBAL.CONC_LOGIN_ID
1966: ,1
1967: FROM ap_supplier_sites_all PVS,
1968: ap_suppliers PV,
1969: zx_party_tax_profile PTP
1970: WHERE
1971: PVS.vendor_site_id = PTP.Party_ID

Line 2041: FROM ap_supplier_sites_all PVS,

2037: ,fnd_global.user_id
2038: ,SYSDATE
2039: ,FND_GLOBAL.CONC_LOGIN_ID
2040: ,1
2041: FROM ap_supplier_sites_all PVS,
2042: ap_suppliers PV,
2043: zx_party_tax_profile PTP
2044: WHERE
2045: PVS.vendor_site_id = PTP.Party_ID

Line 2115: FROM ap_supplier_sites_all PVS,

2111: ,fnd_global.user_id
2112: ,SYSDATE
2113: ,FND_GLOBAL.CONC_LOGIN_ID
2114: ,1
2115: FROM ap_supplier_sites_all PVS,
2116: ap_suppliers PV,
2117: zx_party_tax_profile PTP
2118: WHERE
2119: PVS.vendor_site_id = PTP.Party_ID