DBA Data[Home] [Help]

APPS.ZX_PTP_IMPORT dependencies on ZX_FIRST_PARTY_ORGS_MOAC_V

Line 4418: FROM zx_first_party_orgs_moac_v fpo,

4414: WHERE (( content_owner_id IS NOT NULL
4415: AND NOT EXISTS
4416: (
4417: SELECT 1
4418: FROM zx_first_party_orgs_moac_v fpo,
4419: fnd_lookups LKP,
4420: zx_regimes_usages REG
4421: WHERE fpo.party_tax_profile_id <> -99
4422: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'

Line 4438: FROM zx_first_party_orgs_moac_v fpo,

4434: AND content_owner_name IS NOT NULL
4435: AND NOT EXISTS
4436: (
4437: SELECT 1
4438: FROM zx_first_party_orgs_moac_v fpo,
4439: fnd_lookups lkp,
4440: zx_regimes_usages reg
4441: WHERE fpo.party_tax_profile_id <> -99
4442: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'

Line 4466: FROM zx_first_party_orgs_moac_v fpo,

4462: -- value to id conversion for content_owner_id
4463: UPDATE zx_exemptions_int exe_int
4464: SET content_owner_id = (
4465: SELECT fpo.party_tax_profile_id
4466: FROM zx_first_party_orgs_moac_v fpo,
4467: fnd_lookups lkp,
4468: zx_regimes_usages reg
4469: WHERE FPO.party_tax_profile_id <> -99
4470: AND lkp.lookup_type = 'ZX_PTP_PARTY_TYPE'