DBA Data[Home] [Help]

APPS.JTF_TTY_NACCT_SALES_PUB dependencies on JTF_TTY_MY_RESOURCES_V

Line 165: jtf_tty_my_resources_v repdn

161: and gai.terr_group_account_id = cl_terr_group_account_id
162: -- subsidiaries that are owned by user
163: and exists( select 'Y'
164: from jtf_tty_named_acct_rsc narsc ,
165: jtf_tty_my_resources_v repdn
166: -- jtf_tty_named_accts na,
167: -- jtf_tty_terr_grp_accts ga
168: where narsc.terr_group_account_id = gao.terr_group_account_id
169: -- and ga.named_account_id = na.named_account_id

Line 597: from jtf_tty_my_resources_v grv

593: from jtf_tty_named_acct_rsc ar
594: where ar.terr_group_account_id = l_terr_group_account_id
595: and exists (
596: select 1
597: from jtf_tty_my_resources_v grv
598: , jtf_rs_groups_denorm grpd
599: WHERE ar.resource_id = grv.resource_id
600: and grpd.parent_group_id = grv.parent_group_id
601: and exists (