APPS.MSC_HORIZONTAL_PLAN_SC dependencies on STANDARD

Line 732: sum(safety.safety_stock_quantity * item.standard_cost) cost

728: safety.period_start_date old_date,
729: sum(safety.safety_stock_quantity) new_quantity,
730: safety.organization_id old_quantity,
731: sum(safety.achieved_days_of_supply) dos,
732: sum(safety.safety_stock_quantity * item.standard_cost) cost
733: FROM msc_safety_stocks safety,
734: msc_form_query list ,
735: msc_system_items item
736: WHERE safety.period_start_date <= last_date

Line 770: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost

766: safety.period_start_date old_date,
767: sum(safety.TARGET_SAFETY_STOCK) new_quantity,
768: sum(safety.TOTAL_UNPOOLED_SAFETY_STOCK) old_quantity,
769: sum(safety.target_days_of_supply) dos,
770: sum(safety.TARGET_SAFETY_STOCK * item.standard_cost) cost
771: FROM msc_safety_stocks safety,
772: msc_form_query list ,
773: msc_system_items item
774: WHERE safety.period_start_date <= last_date

Line 807: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost

803: safety.period_start_date old_date,
804: sum(safety.USER_DEFINED_SAFETY_STOCKS) new_quantity,
805: sum(0) old_quantity,
806: sum(safety.user_defined_dos) dos,
807: sum(safety.USER_DEFINED_SAFETY_STOCKS * item.standard_cost) cost
808: FROM msc_safety_stocks safety,
809: msc_form_query list,
810: msc_system_items item
811: WHERE safety.period_start_date <= last_date

Line 1010: cursor standard_cost (p_inventory_item_id number,

1006: WHERE list.query_id = item_list_id
1007: ORDER BY
1008: 1, 2, 6, 4;
1009:
1010: cursor standard_cost (p_inventory_item_id number,
1011: p_sr_instance_id number,
1012: p_organization_id number,
1013: p_plan_id number) is
1014: select nvl(standard_cost,0)

Line 1014: select nvl(standard_cost,0)

1010: cursor standard_cost (p_inventory_item_id number,
1011: p_sr_instance_id number,
1012: p_organization_id number,
1013: p_plan_id number) is
1014: select nvl(standard_cost,0)
1015: from msc_system_items
1016: where inventory_item_id=p_inventory_item_id
1017: and organization_id =p_organization_id
1018: and sr_instance_id =p_sr_instance_id

Line 2498: -- open standard_cost(

2494: -- else
2495: -- add_to_plan(bucket_counter -1,
2496: -- uss_off,
2497: -- activity_rec.new_quantity);
2498: -- open standard_cost(
2499: -- last_item_id,
2500: -- last_inst_id,
2501: -- last_org_id,
2502: -- arg_plan_id);

Line 2503: -- fetch standard_cost into l_standard_cost;

2499: -- last_item_id,
2500: -- last_inst_id,
2501: -- last_org_id,
2502: -- arg_plan_id);
2503: -- fetch standard_cost into l_standard_cost;
2504: -- close standard_cost;
2505: -- add_to_plan(bucket_counter-1,
2506: -- USS_val_OFF,
2507: -- activity_rec.new_quantity*l_standard_cost);

Line 2504: -- close standard_cost;

2500: -- last_inst_id,
2501: -- last_org_id,
2502: -- arg_plan_id);
2503: -- fetch standard_cost into l_standard_cost;
2504: -- close standard_cost;
2505: -- add_to_plan(bucket_counter-1,
2506: -- USS_val_OFF,
2507: -- activity_rec.new_quantity*l_standard_cost);
2508: --

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

2503: -- fetch standard_cost into l_standard_cost;
2504: -- close standard_cost;
2505: -- add_to_plan(bucket_counter-1,
2506: -- USS_val_OFF,
2507: -- activity_rec.new_quantity*l_standard_cost);
2508: --
2509: -- end if;
2510: end if;
2511: END IF;

Line 3227: -- if a user selects a standard item then

3223:
3224: -- for capacity statement we always has
3225: -- to check the ASL of ATO model
3226:
3227: -- if a user selects a standard item then
3228: -- capacity_item_id will contain the standard item
3229: -- and req_item_id will contain the standard item
3230: -- else if a user selects a model / config item
3231: -- capacity_item_id will contain the base model

Line 3228: -- capacity_item_id will contain the standard item

3224: -- for capacity statement we always has
3225: -- to check the ASL of ATO model
3226:
3227: -- if a user selects a standard item then
3228: -- capacity_item_id will contain the standard item
3229: -- and req_item_id will contain the standard item
3230: -- else if a user selects a model / config item
3231: -- capacity_item_id will contain the base model
3232: -- req_item_id will contain all the configs and model to

Line 3229: -- and req_item_id will contain the standard item

3225: -- to check the ASL of ATO model
3226:
3227: -- if a user selects a standard item then
3228: -- capacity_item_id will contain the standard item
3229: -- and req_item_id will contain the standard item
3230: -- else if a user selects a model / config item
3231: -- capacity_item_id will contain the base model
3232: -- req_item_id will contain all the configs and model to
3233: -- query requirements.