DBA Data[Home] [Help]

APPS.CSF_TASK_ADDRESS_PVT dependencies on JTF_TASK_STATUSES_VL

Line 417: jtf_task_statuses_vl jts

413: FROM jtf_tasks_b t,
414: jtf_task_types_b tt,
415: hz_locations l,
416: fnd_territories_tl tl,
417: jtf_task_statuses_vl jts
418: WHERE tt.task_type_id = t.task_type_id
419: AND t.location_id is not null
420: AND l.location_id = t.location_id
421: AND tl.territory_code = l.country

Line 452: jtf_task_statuses_vl jts

448: jtf_task_types_b tt,
449: hz_party_sites hps,
450: hz_locations l,
451: fnd_territories_tl tl,
452: jtf_task_statuses_vl jts
453: WHERE tt.task_type_id = t.task_type_id
454: AND t.address_id is not null
455: AND t.address_id = hps.party_site_id
456: AND l.location_id = hps.location_id

Line 489: jtf_task_statuses_vl jts,

485: FROM jtf_tasks_b t,
486: jtf_task_types_b tt,
487: hz_locations l,
488: fnd_territories_tl tl,
489: jtf_task_statuses_vl jts,
490: CSF_SPATIAL_CTRY_MAPPINGS sp
491: WHERE tt.task_type_id = t.task_type_id
492: AND t.location_id is not null
493: AND l.location_id = t.location_id

Line 527: jtf_task_statuses_vl jts,

523: jtf_task_types_b tt,
524: hz_party_sites hps,
525: hz_locations l,
526: fnd_territories_tl tl,
527: jtf_task_statuses_vl jts,
528: CSF_SPATIAL_CTRY_MAPPINGS sp
529: WHERE tt.task_type_id = t.task_type_id
530: AND t.address_id is not null
531: AND t.address_id = hps.party_site_id