APPS.ZX_PTP_MIGRATE_PKG dependencies on AP_SUPPLIERS

Line 1339: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP

1335: ---Bug 4054883
1336:
1337: /*CURSOR C_SUPPLIER_TYPE IS
1338: SELECT POV.VENDOR_ID
1339: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP
1340: WHERE POV.VENDOR_ID = PTP.PARTY_ID
1341: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
1342: AND VENDOR_TYPE_LOOKUP_CODE is not null
1343: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/

Line 1425: FROM ap_suppliers PV

1421: ,fnd_global.user_id -- Who Columns
1422: ,SYSDATE -- Who Columns
1423: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1424: , 1
1425: FROM ap_suppliers PV
1426: WHERE VENDOR_ID = nvl(p_party_ID,VENDOR_ID)
1427: AND not exists (select 1 from zx_party_tax_profile
1428: where party_id = PV.party_id and Party_Type_Code = 'THIRD_PARTY'));
1429:

Line 1498: FROM ap_suppliers PV,

1494: ,fnd_global.user_id
1495: ,SYSDATE
1496: ,FND_GLOBAL.CONC_LOGIN_ID
1497: ,1
1498: FROM ap_suppliers PV,
1499: zx_party_tax_profile PTP
1500: WHERE
1501: PV.Party_id = PTP.Party_ID
1502: AND PTP.Party_Type_code = 'SUPPLIER'

Line 1741: ap_suppliers PV,

1737: ,nvl(PVS.offset_tax_flag,'N') ALLOW_OFFSET_TAX_FLAG -- Allow_Offset_Tax_Flag
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

Line 1847: ap_suppliers pv,

1843: ,PV.End_Date_Active EFFECTIVE_TO-- Effective to
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

Line 1927: ap_suppliers Pv

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
1931: WHERE party_id = pvs.VENDOR_SITE_ID and Party_Type_Code = 'SUPPLIER_SITE'));

Line 1994: ap_suppliers PV,

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
1998: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 2088: ap_suppliers PV,

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
2092: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 2162: ap_suppliers PV,

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
2166: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 2236: ap_suppliers PV,

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
2240: AND PTP.Party_Type_code = 'SUPPLIER_SITE'

Line 2850: FROM ap_suppliers POV ,

2846: Null,
2847: NULL,
2848: fnd_global.PROG_APPL_ID,
2849: fnd_global.CONC_PROGRAM_ID
2850: FROM ap_suppliers POV ,
2851: ZX_PARTY_TAX_PROFILE PTP
2852: WHERE POV.PARTY_ID = PTP.PARTY_ID
2853: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
2854: AND POV.VENDOR_TYPE_LOOKUP_CODE is not null;