DBA Data[Home] [Help]

APPS.CSP_EXCESS_PARTS_PVT dependencies on JTF_TERR_TYPES_ALL

Line 2463: JTF_TERR_TYPES_ALL tty

2459: tall.terr_id
2460: from
2461: jtf_terr_all tall,
2462: jtf_terr_results_gt_mt tmt,
2463: JTF_TERR_TYPES_ALL tty
2464: where
2465: tall.terr_id = tmt.terr_id
2466: and tty.application_short_name = 'CSP'
2467: and tty.org_id = tall.org_id

Line 2724: jtf_terr_types_all tty

2720: cursor c_terr_results is
2721: select tall.terr_id
2722: from jtf_terr_all tall,
2723: jtf_terr_results_gt_mt tmt,
2724: jtf_terr_types_all tty
2725: where tall.terr_id = tmt.terr_id
2726: and tty.application_short_name = 'CSP'
2727: and tty.org_id = tall.org_id
2728: and tall.territory_type_id = tty.terr_type_id