APPS.GMP_HORIZONTAL_PDR_PKG dependencies on STANDARD

Line 677: sum(safety.safety_stock_quantity * gpi.standard_cost) cost

673: safety.period_start_date old_date,
674: sum(safety.safety_stock_quantity) new_quantity,
675: safety.organization_id old_quantity,
676: sum(safety.achieved_days_of_supply) dos,
677: sum(safety.safety_stock_quantity * gpi.standard_cost) cost
678: FROM msc_safety_stocks safety,
679: -- msc_form_query list ,
680: -- msc_system_items item
681: gmp_pdr_items_gtmp gpi

Line 727: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost

723: safety.period_start_date old_date,
724: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
725: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
726: sum(safety.target_days_of_supply) dos,
727: sum(safety.TARGET_SAFETY_STOCK * gpi.standard_cost) cost
728: FROM msc_safety_stocks safety,
729: -- msc_form_query list ,
730: -- msc_system_items item
731: gmp_pdr_items_gtmp gpi

Line 776: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost

772: safety.period_start_date old_date,
773: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
774: sum(0) old_quantity,
775: sum(safety.user_defined_dos) dos,
776: sum(safety.USER_DEFINED_SAFETY_STOCKS * gpi.standard_cost) cost
777: FROM msc_safety_stocks safety,
778: -- msc_form_query list,
779: -- msc_system_items item
780: gmp_pdr_items_gtmp gpi

Line 1051: cursor standard_cost (p_inventory_item_id number,

1047: */
1048: ORDER BY
1049: 1, 2, 5, 3 ;
1050: /*
1051: cursor standard_cost (p_inventory_item_id number,
1052: p_sr_instance_id number,
1053: p_organization_id number,
1054: p_plan_id number) is
1055: select nvl(standard_cost,0)

Line 1055: select nvl(standard_cost,0)

1051: cursor standard_cost (p_inventory_item_id number,
1052: p_sr_instance_id number,
1053: p_organization_id number,
1054: p_plan_id number) is
1055: select nvl(standard_cost,0)
1056: from msc_system_items
1057: where inventory_item_id=p_inventory_item_id
1058: and organization_id =p_organization_id
1059: and sr_instance_id =p_sr_instance_id

Line 2839: -- open standard_cost(

2835: -- else
2836: -- add_to_plan(bucket_counter -1,
2837: -- uss_off,
2838: -- activity_rec.new_quantity);
2839: -- open standard_cost(
2840: -- last_item_id,
2841: -- last_inst_id,
2842: -- last_org_id,
2843: -- G_plan_id);

Line 2844: -- fetch standard_cost into l_standard_cost;

2840: -- last_item_id,
2841: -- last_inst_id,
2842: -- last_org_id,
2843: -- G_plan_id);
2844: -- fetch standard_cost into l_standard_cost;
2845: -- close standard_cost;
2846: -- add_to_plan(bucket_counter-1,
2847: -- USS_val_OFF,
2848: -- activity_rec.new_quantity*l_standard_cost);

Line 2845: -- close standard_cost;

2841: -- last_inst_id,
2842: -- last_org_id,
2843: -- G_plan_id);
2844: -- fetch standard_cost into l_standard_cost;
2845: -- close standard_cost;
2846: -- add_to_plan(bucket_counter-1,
2847: -- USS_val_OFF,
2848: -- activity_rec.new_quantity*l_standard_cost);
2849: --

Line 2848: -- activity_rec.new_quantity*l_standard_cost);

2844: -- fetch standard_cost into l_standard_cost;
2845: -- close standard_cost;
2846: -- add_to_plan(bucket_counter-1,
2847: -- USS_val_OFF,
2848: -- activity_rec.new_quantity*l_standard_cost);
2849: --
2850: -- end if;
2851: END IF;
2852: END IF;