APPS.MSC_SUPPLIER_PKG dependencies on MSC_SUPPLIERS_F

Line 64: 50: populate msc_suppliers_f from ((l_qid_avail_cum join dense_org_key) join l_qid_req)

60: 10: populate l_qid_req from source
61: 20: populate l_qid_avail_org from source
62: 30: populate l_qid_avail_req from ((l_qid_req grouped to all orgs) union l_qid_avail_org distinct on org)
63: 40: populate l_qid_avail_cum from (dense_time_key join l_qid_avail_req)
64: 50: populate msc_suppliers_f from ((l_qid_avail_cum join dense_org_key) join l_qid_req)
65: */
66:
67: procedure populate_details(errbuf out nocopy varchar2, retcode out nocopy number,
68: p_plan_id number, p_plan_run_id number) AS

Line 543: insert into msc_suppliers_f (

539: --dbms_output.put_line('l_stmt_id='|| l_stmt_id||' count=' || SQL%ROWCOUNT || ' l_qid_avail_cum=' || l_qid_avail_cum);
540: commit;
541:
542: l_stmt_id:=50;
543: insert into msc_suppliers_f (
544: plan_id,
545: plan_run_id,
546: sr_instance_id,
547: organization_id,

Line 674: insert into msc_suppliers_f (

670: is
671: l_category_set_id1 number := fnd_profile.value('MSC_HUB_CAT_SET_ID_1');
672: begin
673: -- level 1
674: insert into msc_suppliers_f (
675: plan_id, plan_run_id,
676: sr_instance_id, organization_id,
677: supplier_id, supplier_site_id, region_id,
678: inventory_item_id,

Line 720: msc_suppliers_f f,

716: sysdate, fnd_global.user_id, fnd_global.login_id,
717: fnd_global.conc_program_id, fnd_global.conc_login_id,
718: fnd_global.prog_appl_id, fnd_global.conc_request_id
719: from
720: msc_suppliers_f f,
721: msc_phub_item_categories_mv q
722: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
723: and f.aggr_type=0
724: and f.sr_instance_id=q.sr_instance_id(+)

Line 738: insert into msc_suppliers_f (

734:
735: commit;
736:
737: -- level 2
738: insert into msc_suppliers_f (
739: plan_id, plan_run_id,
740: sr_instance_id, organization_id,
741: supplier_id, supplier_site_id, region_id,
742: inventory_item_id,

Line 807: msc_suppliers_f f,

803: sum(f.buy_order_value) buy_order_value,
804: sum(f.buy_order_value2) buy_order_value2,
805: sum(f.buy_order_count) buy_order_count
806: from
807: msc_suppliers_f f,
808: msc_phub_fiscal_periods_mv fp
809: where f.plan_id = p_plan_id and f.plan_run_id = p_plan_run_id
810: and f.aggr_type between 42 and 44
811: and f.analysis_date between fp.start_date and fp.end_date

Line 844: delete from msc_suppliers_f

840: retcode := 0;
841: errbuf := NULL;
842:
843: --pabram.. will add code later to delete/truncate table/partition for this plan
844: delete from msc_suppliers_f
845: where plan_id = p_plan_id
846: and plan_run_id = nvl(p_plan_run_id,plan_run_id);
847:
848: commit;