[Home] [Help]
1468: end summarize_information;
1469:
1470: PROCEDURE update_parts_loop IS
1471: begin
1472: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_PLS';
1473: insert into csp_sup_dem_pls(
1474: inventory_item_id,
1475: organization_id,
1476: parts_loop_id,
1469:
1470: PROCEDURE update_parts_loop IS
1471: begin
1472: EXECUTE IMMEDIATE 'TRUNCATE TABLE '||l_oracle_schema||'.CSP_SUP_DEM_PLS';
1473: insert into csp_sup_dem_pls(
1474: inventory_item_id,
1475: organization_id,
1476: parts_loop_id,
1477: purchase_orders,