APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_APPS_INSTANCES

Line 5392: FROM MSC_APPS_INSTANCES

5388: ELSE
5389: lv_tbl:= 'MSC_ORG_AGGR_IBUC';
5390:
5391: SELECT LAST_IBUC_COLL_DATE INTO lv_last_ibuc_coll_date
5392: FROM MSC_APPS_INSTANCES
5393: WHERE INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id;
5394:
5395: DELETE FROM MSC_ORG_AGGR_IBUC
5396: WHERE SAMPLE_DATE = trunc(lv_last_ibuc_coll_date);

Line 5553: FROM MSC_APPS_INSTANCES WHERE instance_id = lv_instance_id ;

5549:
5550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Aset id ---' || lv_assign_set_id) ;
5551:
5552: SELECT IBUCCP_LCID, lcid INTO n1, n2
5553: FROM MSC_APPS_INSTANCES WHERE instance_id = lv_instance_id ;
5554:
5555: lv_sql_stmt :=
5556: ' UPDATE MSC_ORG_AGGR_IBUC MOAI '
5557: ||' set MOAI.SUPPLYING_ORG_ID =('

Line 5600: UPDATE MSC_APPS_INSTANCES

5596:
5597: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Popualted Org info. for Install base Aggregations');
5598: COMMIT;
5599:
5600: UPDATE MSC_APPS_INSTANCES
5601: SET IBUCCP_LCID = n2 WHERE INSTANCE_ID= lv_instance_id;
5602: COMMIT;
5603:
5604: EXCEPTION