eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OPI_DBI_PTP_BASELINE_PKG dependencies on ISC_DBI_PLAN_ORGANIZATIONS

Line 95: from isc_dbi_plan_organizations org,

91: bulk collect into l_org_list, l_existing_list, l_from_dates
92: from (select /*+ no_merge use_hash(sched,setup,plan,org) */
93: distinct org.organization_id,
94: sched.from_date
95: from isc_dbi_plan_organizations org,
96: isc_dbi_plans plan,
97: opi_dbi_baseline_schedules sched,
98: opi_dbi_baseline_plans setup
99: where sched.next_collection_date <= g_sysdate

Line 178: isc_dbi_plan_organizations orgs

174: sched.from_date
175: from opi_dbi_baseline_schedules sched,
176: opi_dbi_baseline_plans setup,
177: isc_dbi_plans plan,
178: isc_dbi_plan_organizations orgs
179: where sched.next_collection_date <= :g_sysdate
180: and sched.schedule_type = 1
181: and sched.baseline_id = setup.baseline_id
182: and setup.plan_name = plan.compile_designator

Line 223: isc_dbi_plan_organizations orgs

219: sched.from_date
220: from opi_dbi_baseline_schedules sched,
221: opi_dbi_baseline_plans setup,
222: isc_dbi_plans plan,
223: isc_dbi_plan_organizations orgs
224: where sched.next_collection_date <= :g_sysdate
225: and sched.schedule_type = 1
226: and sched.baseline_id = setup.baseline_id
227: and setup.plan_name = plan.compile_designator

Line 699: from isc_dbi_plan_organizations org,

695: bulk collect into l_org_list, l_existing_list, l_from_dates
696: from (select /*+ no_merge use_hash(sched,setup,plan,org) */
697: distinct org.organization_id,
698: sched.from_date
699: from isc_dbi_plan_organizations org,
700: isc_dbi_plans plan,
701: opi_dbi_baseline_schedules sched,
702: opi_dbi_baseline_plans setup
703: where sched.next_collection_date <= g_sysdate

Line 838: isc_dbi_plan_organizations orgs

834: sched.from_date
835: from opi_dbi_baseline_schedules sched,
836: opi_dbi_baseline_plans setup,
837: isc_dbi_plans plan,
838: isc_dbi_plan_organizations orgs
839: where sched.next_collection_date <= :g_sysdate
840: and sched.schedule_type = 1
841: and sched.baseline_id = setup.baseline_id
842: and setup.plan_name = plan.compile_designator

Line 870: isc_dbi_plan_organizations orgs

866: sched.from_date
867: from opi_dbi_baseline_schedules sched,
868: opi_dbi_baseline_plans setup,
869: isc_dbi_plans plan,
870: isc_dbi_plan_organizations orgs
871: where sched.next_collection_date <= :g_sysdate
872: and sched.schedule_type = 1
873: and sched.baseline_id = setup.baseline_id
874: and setup.plan_name = plan.compile_designator

Line 1239: ISC_DBI_PLAN_ORGANIZATIONS orgs

1235: select orgs.organization_id, count(orgs.plan_id) num_of_plans
1236: from OPI_DBI_BASELINE_SCHEDULES sched,
1237: OPI_DBI_BASELINE_PLANS setup,
1238: ISC_DBI_PLANS plan,
1239: ISC_DBI_PLAN_ORGANIZATIONS orgs
1240: where sched.next_collection_date <= g_sysdate
1241: and sched.schedule_type = 1
1242: and sched.baseline_id = setup.baseline_id
1243: and setup.plan_name = plan.compile_designator

Line 1713: ISC_DBI_PLAN_ORGANIZATIONS orgs

1709: from OPI_DBI_BASELINE_DEFINITIONS def,
1710: OPI_DBI_BASELINE_SCHEDULES sched,
1711: OPI_DBI_BASELINE_PLANS setup,
1712: ISC_DBI_PLANS plan,
1713: ISC_DBI_PLAN_ORGANIZATIONS orgs
1714: where def.baseline_id = sched.baseline_id
1715: and sched.next_collection_date <= g_sysdate
1716: and sched.schedule_type = 1
1717: and sched.baseline_id = setup.baseline_id

Line 1759: ISC_DBI_PLAN_ORGANIZATIONS orgs

1755: where cost.organization_id in
1756: (select orgs.organization_id
1757: from OPI_DBI_BASELINE_PLANS setup,
1758: ISC_DBI_PLANS plan,
1759: ISC_DBI_PLAN_ORGANIZATIONS orgs
1760: where setup.baseline_id = l_baseline_record.baseline_id
1761: and setup.plan_name = plan.compile_designator
1762: and setup.owning_org_id = plan.organization_id
1763: and plan.plan_id = orgs.plan_id

Line 1774: ISC_DBI_PLAN_ORGANIZATIONS orgs

1770: where cost.organization_id in
1771: (select orgs.organization_id
1772: from OPI_DBI_BASELINE_PLANS setup,
1773: ISC_DBI_PLANS plan,
1774: ISC_DBI_PLAN_ORGANIZATIONS orgs
1775: where setup.baseline_id = l_baseline_record.baseline_id
1776: and setup.plan_name = plan.compile_designator
1777: and setup.owning_org_id = plan.organization_id
1778: and plan.plan_id = orgs.plan_id

Line 1789: ISC_DBI_PLAN_ORGANIZATIONS orgs

1785: where conv.organization_id in
1786: (select orgs.organization_id
1787: from OPI_DBI_BASELINE_PLANS setup,
1788: ISC_DBI_PLANS plan,
1789: ISC_DBI_PLAN_ORGANIZATIONS orgs
1790: where setup.baseline_id = l_baseline_record.baseline_id
1791: and setup.plan_name = plan.compile_designator
1792: and setup.owning_org_id = plan.organization_id
1793: and plan.plan_id = orgs.plan_id

Line 1804: ISC_DBI_PLAN_ORGANIZATIONS orgs

1800: where conv.organization_id in
1801: (select orgs.organization_id
1802: from OPI_DBI_BASELINE_PLANS setup,
1803: ISC_DBI_PLANS plan,
1804: ISC_DBI_PLAN_ORGANIZATIONS orgs
1805: where setup.baseline_id = l_baseline_record.baseline_id
1806: and setup.plan_name = plan.compile_designator
1807: and setup.owning_org_id = plan.organization_id
1808: and plan.plan_id = orgs.plan_id