[Home] [Help]
731: IF l_new_orgs IS NOT NULL THEN
732: l_new_orgs := '(' || substrb(l_new_orgs, 1, instrb(l_new_orgs, ',', -1, 1)-1) || ')';
733: BIS_COLLECTION_UTILITIES.put_line('Collect item cost for new Process-Enabled organizations.');
734: l_stmt_num := 30;
735: l_stmt := 'INSERT INTO opi_pmi_cost_param_gtmp
736: (
737: item_id,
738: whse_code,
739: orgn_code,
753: EXECUTE IMMEDIATE l_stmt;
754:
755: BIS_COLLECTION_UTILITIES.put_line(TO_CHAR(SQL%ROWCOUNT) || ' org items identified for costing.');
756:
757: opi_pmi_cost.get_cost;
758:
759: END IF;
760:
761: IF l_existing_orgs IS NOT NULL THEN
761: IF l_existing_orgs IS NOT NULL THEN
762: l_existing_orgs := '(' || substrb(l_existing_orgs, 1, instrb(l_existing_orgs, ',', -1, 1)-1) || ')';
763: BIS_COLLECTION_UTILITIES.put_line('Adding item cost for new Process-Enabled organizations...');
764: l_stmt_num := 35;
765: l_stmt := 'INSERT INTO opi_pmi_cost_param_gtmp
766: (
767: item_id,
768: whse_code,
769: orgn_code,
783: EXECUTE IMMEDIATE l_stmt;
784:
785: BIS_COLLECTION_UTILITIES.put_line(TO_CHAR(SQL%ROWCOUNT) || ' org items identified for costing.');
786:
787: opi_pmi_cost.get_cost;
788:
789: END IF;
790:
791: BIS_COLLECTION_UTILITIES.put_line('l_new_orgs=' || l_new_orgs);
877: ) org_dates,
878: ic_whse_mst w,
879: mtl_system_items_b msi,
880: ic_item_mst_b i,
881: opi_pmi_cost_result_gtmp cst
882: where
883: w.mtl_organization_id = org_dates.organization_id
884: AND msi.organization_id = w.mtl_organization_id
885: AND i.item_no = msi.segment1
928: :g_sysdate from_date,
929: null to_date,
930: :l_source source
931: from
932: opi_pmi_cost_result_gtmp cst,
933: ic_whse_mst w,
934: ic_item_mst_b i,
935: mtl_system_items_b msi
936: where