[Home] [Help]
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
100: and sched.schedule_type = 1
101: and sched.baseline_id = setup.baseline_id
102: and setup.plan_name = plan.compile_designator
172: (select /*+ no_merge use_hash(sched,setup,plan,orgs) */
173: orgs.organization_id,
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
217: (select /*+ no_merge use_hash(sched,setup,plan,orgs) */
218: orgs.organization_id,
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
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
704: and sched.schedule_type = 1
705: and sched.baseline_id = setup.baseline_id
706: and setup.plan_name = plan.compile_designator
832: mtl_system_Items_b msi,
833: (select orgs.organization_id,
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
864: from
865: (select orgs.organization_id,
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
1183: (
1184: select sched.baseline_id,
1185: sched.from_date
1186: from OPI_DBI_BASELINE_SCHEDULES sched,
1187: OPI_DBI_BASELINE_PLANS setup
1188: where sched.next_collection_date <= g_sysdate
1189: and sched.schedule_type = 1
1190: and sched.baseline_id = setup.baseline_id
1191: ) boundary
1233: from
1234: (
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
1260: BEGIN
1261: select count(*)
1262: into l_count
1263: from OPI_DBI_BASELINE_SCHEDULES sched,
1264: OPI_DBI_BASELINE_PLANS setup,
1265: ISC_DBI_PLANS plan
1266: where sched.baseline_id = setup.baseline_id
1267: and setup.plan_name = plan.compile_designator
1268: and setup.owning_org_id = plan.organization_id
1295: RPAD(TO_CHAR(plan.data_start_date, 'DD-MON-YYYY'), 20, ' ')
1296: bulk collect into l_strings
1297: from OPI_DBI_BASELINE_DEFINITIONS def,
1298: OPI_DBI_BASELINE_SCHEDULES sched,
1299: OPI_DBI_BASELINE_PLANS setup,
1300: ISC_DBI_PLANS plan
1301: where def.baseline_id = sched.baseline_id
1302: and sched.baseline_id = setup.baseline_id
1303: and setup.plan_name = plan.compile_designator
1451: plan.organization_id,
1452: plan.cutoff_date
1453: from
1454: opi_dbi_baseline_schedules sched,
1455: opi_dbi_baseline_plans setup,
1456: isc_dbi_plans plan
1457: where sched.next_collection_date <= :g_sysdate
1458: and sched.schedule_type = 1
1459: and sched.baseline_id = setup.baseline_id
1707: g_last_updated_by,
1708: g_last_update_login
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
1731: g_sysdate,
1732: g_last_updated_by,
1733: g_last_update_login
1734: from OPI_DBI_BASELINE_SCHEDULES sched,
1735: OPI_DBI_BASELINE_PLANS setup,
1736: ISC_DBI_PLANS plan
1737: where def.baseline_id = sched.baseline_id
1738: and sched.baseline_id = setup.baseline_id
1739: and setup.plan_name = plan.compile_designator
1753: update OPI_DBI_PTP_COST cost
1754: set to_date = l_baseline_record.from_date
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
1768: update OPI_DBI_PTP_COST cost
1769: set from_date = l_baseline_record.from_date
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
1783: update OPI_DBI_PTP_CONV conv
1784: set to_date = l_baseline_record.from_date
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
1798: update OPI_DBI_PTP_CONV conv
1799: set from_date = l_baseline_record.from_date
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