DBA Data[Home] [Help]

APPS.JTF_TTY_OVERLAP_WEBADI_PKG dependencies on JTF_TERR_ALL

Line 89: ,jtf_terr_all TER

85: select distinct TG.terr_group_name
86: , TER.name parent_territory
87: from jtf_tty_terr_grp_accts TGA
88: ,jtf_tty_terr_groups TG
89: ,jtf_terr_all TER
90: where TGA.named_account_id = c_named_account_id
91: and TGA.terr_group_id = TG.terr_group_id
92: and TG.parent_terr_id = TER.terr_id
93: and trunc(TG.active_from_date) <= trunc(sysdate)