APPS.ZX_PTP_MIGRATE_PKG dependencies on AP_SUPPLIERS

Line 1219: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP

1215: ---Bug 4054883
1216:
1217: /*CURSOR C_SUPPLIER_TYPE IS
1218: SELECT POV.VENDOR_ID
1219: FROM ap_suppliers POV , ZX_PARTY_TAX_PROFILE PTP
1220: WHERE POV.VENDOR_ID = PTP.PARTY_ID
1221: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
1222: AND VENDOR_TYPE_LOOKUP_CODE is not null
1223: AND VENDOR_TYPE_LOOKUP_CODE <> 'TAX AUTHORITY';*/

Line 1305: FROM ap_suppliers PV

1301: ,fnd_global.user_id -- Who Columns
1302: ,SYSDATE -- Who Columns
1303: ,FND_GLOBAL.CONC_LOGIN_ID -- Who Columns
1304: , 1
1305: FROM ap_suppliers PV
1306: WHERE VENDOR_ID = nvl(p_party_ID,VENDOR_ID)
1307: AND not exists (select 1 from zx_party_tax_profile
1308: where party_id = PV.party_id and Party_Type_Code = 'THIRD_PARTY'));
1309:

Line 1378: FROM ap_suppliers PV,

1374: ,fnd_global.user_id
1375: ,SYSDATE
1376: ,FND_GLOBAL.CONC_LOGIN_ID
1377: ,1
1378: FROM ap_suppliers PV,
1379: zx_party_tax_profile PTP
1380: WHERE
1381: PV.Party_id = PTP.Party_ID
1382: AND PTP.Party_Type_code = 'SUPPLIER'

Line 1621: ap_suppliers PV,

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

Line 1727: ap_suppliers pv,

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

Line 1807: ap_suppliers Pv

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

Line 1874: ap_suppliers PV,

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

Line 1968: ap_suppliers PV,

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

Line 2042: ap_suppliers PV,

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

Line 2116: ap_suppliers PV,

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

Line 2730: FROM ap_suppliers POV ,

2726: Null,
2727: NULL,
2728: fnd_global.PROG_APPL_ID,
2729: fnd_global.CONC_PROGRAM_ID
2730: FROM ap_suppliers POV ,
2731: ZX_PARTY_TAX_PROFILE PTP
2732: WHERE POV.PARTY_ID = PTP.PARTY_ID
2733: AND PTP.PARTY_TYPE_CODE = 'SUPPLIER'
2734: AND POV.VENDOR_TYPE_LOOKUP_CODE is not null;