[Home] [Help]
37: l_ebs_organization_code mth_run_log.ebs_organization_code%TYPE;
38: l_from_date mth_run_log.from_date%TYPE;--from date of the run
39: l_to_date mth_run_log.to_date%TYPE;--to date of the run
40: l_source mth_run_log.source%TYPE;--process or discrete. Not used currently
41: l_system_fk_key mth_systems_setup.system_pk_key%TYPE;
42: l_creation_date mth_run_log.creation_date%TYPE;--who column
43: l_last_update_date mth_run_log.last_update_date%TYPE;--who column
44: l_creation_system_id mth_run_log.creation_system_id%TYPE;--who column
45: l_last_update_system_id mth_run_log.last_update_system_id%TYPE;--who column
55: --the rows in the mth_run_log will be at organization granularity
56: CURSOR c_ebs_orgs IS
57: SELECT ebs_organization_id,organization_code,
58: source,plant_pk,system_fk_key,from_date
59: FROM mth_plants_d, mth_systems_setup,mth_organizations_l
60: WHERE system_pk_key = system_fk_key
61: AND system_pk = p_db_global_name
62: AND NVL(to_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)--pick active plants only
63: AND plant_fk_key=plant_pk_key;
244: l_fact_table mth_run_log.fact_table%TYPE;--fact table
245: l_sysdate DATE := sysdate;--variable for sysdate
246: l_last_update_system_id mth_run_log.last_update_system_id%TYPE;
247: l_last_update_date mth_run_log.last_update_date%TYPE;
248: l_system_fk_key mth_systems_setup.system_pk_key%TYPE;
249: l_to_date mth_run_log.to_date%TYPE;--variable for storing to_date
250: l_from_date mth_run_log.from_date%TYPE;--variable for storing from_date
251: l_ebs_organization_id mth_run_log.ebs_organization_id%TYPE;
252: --Hub organization code
257:
258: CURSOR c_ebs_orgs
259: IS
260: SELECT ebs_organization_id,system_fk_key
261: FROM mth_plants_d, mth_systems_setup,mth_organizations_l
262: WHERE system_pk_key = system_fk_key
263: AND system_pk = p_db_global_name
264: AND NVL(to_date,TRUNC(SYSDATE)) >= TRUNC(SYSDATE)--pick active plants only
265: AND plant_fk_key=plant_pk_key;