APPS.ISC_DBI_MSC_OBJECTS_C dependencies on STANDARD

Line 450: 'PLANNING_MAKE_BUY_CODE,R_CFM_ROUTING_FLAG,STANDARD_COST,UOM_CODE,'||

446: 'PLAN_ID,TRANSACTION_ID,ORGANIZATION_ID,TIME_NEW_SCH_DATE_ID,SOURCE_ORGANIZATION_ID,'||
447: 'SOURCE_SR_INSTANCE_ID,SOURCE_SUPPLIER_ID,SOURCE_SUPPLIER_SITE_ID,SR_INSTANCE_ID,SR_INVENTORY_ITEM_ID,'||
448: 'SR_SUPPLIER_ID,SUPPLIER_ID,SUPPLIER_SITE_ID,BOM_ITEM_TYPE,DISPOSITION_STATUS_TYPE,'||
449: 'IN_SOURCE_PLAN,ITEM_PRICE,NEW_ORDER_QUANTITY,NEW_PROCESSING_DAYS,NEW_SCHEDULE_DATE,ORDER_TYPE,'||
450: 'PLANNING_MAKE_BUY_CODE,R_CFM_ROUTING_FLAG,STANDARD_COST,UOM_CODE,'||
451: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
452: 'VALUES(plan_id,transaction_id,organization_id,time_new_sch_date_id,source_organization_id,'||
453: 'source_sr_instance_id,source_supplier_id,source_supplier_site_id,sr_instance_id,'||
454: 'sr_inventory_item_id,sr_supplier_id,supplier_id,supplier_site_id,bom_item_type,'||

Line 457: 'standard_cost,uom_code,'||

453: 'source_sr_instance_id,source_supplier_id,source_supplier_site_id,sr_instance_id,'||
454: 'sr_inventory_item_id,sr_supplier_id,supplier_id,supplier_site_id,bom_item_type,'||
455: 'disposition_status_type,in_source_plan,item_price,new_order_quantity,'||
456: 'new_processing_days,new_schedule_date,order_type,planning_make_buy_code,r_cfm_routing_flag,'||
457: 'standard_cost,uom_code,'||
458: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login ) '||
459: 'WHEN union_flag = 5 THEN '||
460: 'INTO isc_dbi_inv_detail_f (PLAN_ID,ORGANIZATION_ID,'||
461: 'SR_INVENTORY_ITEM_ID,TIME_DETAIL_DATE_ID,CARRYING_COST,DETAIL_DATE,INVENTORY_COST,'||

Line 489: 'AVERAGE_DISCOUNT,LIST_PRICE,SELLING_PRICE,STANDARD_COST,USING_REQUIREMENT_QUANTITY,'||

485: 'WHEN union_flag = 8 THEN '||
486: 'INTO isc_dbi_demands_f (PLAN_ID,ORGANIZATION_ID,SR_INVENTORY_ITEM_ID,'||
487: 'DEMAND_ID,TIME_AS_DMD_COMP_DATE,TIME_DMD_DATE_ID,TIME_USING_AS_DMD_DATE,ASSEMBLY_DEMAND_COMP_DATE,'||
488: 'ORIGINATION_TYPE,UOM_CODE,USING_ASSEMBLY_DEMAND_DATE,'||
489: 'AVERAGE_DISCOUNT,LIST_PRICE,SELLING_PRICE,STANDARD_COST,USING_REQUIREMENT_QUANTITY,'||
490: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
491: 'VALUES(plan_id,organization_id,sr_inventory_item_id,demand_id,'||
492: 'time_as_dmd_comp_date,time_dmd_date_id,time_using_as_dmd_date,assembly_demand_comp_date,'||
493: 'origination_type,uom_code,using_assembly_demand_date,'||

Line 494: 'average_discount,list_price,selling_price,standard_cost,using_requirement_quantity,'||

490: 'CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE,LAST_UPDATE_LOGIN) '||
491: 'VALUES(plan_id,organization_id,sr_inventory_item_id,demand_id,'||
492: 'time_as_dmd_comp_date,time_dmd_date_id,time_using_as_dmd_date,assembly_demand_comp_date,'||
493: 'origination_type,uom_code,using_assembly_demand_date,'||
494: 'average_discount,list_price,selling_price,standard_cost,using_requirement_quantity,'||
495: 'created_by,creation_date,last_updated_by,last_update_date,last_update_login) '||
496: 'WHEN union_flag = 9 THEN '||
497: 'INTO isc_dbi_periods (ORGANIZATION_ID,PERIOD_SET_NAME,PERIOD_NAME,'||
498: 'START_DATE,END_DATE,YEAR_START_DATE,QUARTER_START_DATE,'||

Line 530: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

526: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
527: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
528: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
529: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
530: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
531: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
532: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
533: 'null PRODUCTION_COST,null PURCHASING_COST,'||
534: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 560: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

556: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
557: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
558: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
559: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
560: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
561: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
562: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
563: 'null PRODUCTION_COST,null PURCHASING_COST,'||
564: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 590: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

586: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
587: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
588: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
589: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
590: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
591: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
592: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
593: 'null PRODUCTION_COST,null PURCHASING_COST,'||
594: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 620: 'it.planning_make_buy_code,r1.cfm_routing_flag R_CFM_ROUTING_FLAG,it.standard_cost,'||

616: 's.source_sr_instance_id,s.source_supplier_id,s.source_supplier_site_id,s.sr_instance_id,'||
617: 'tp.sr_tp_id SR_SUPPLIER_ID,s.supplier_id,s.supplier_site_id,it.bom_item_type,'||
618: 's.disposition_status_type,it.in_source_plan,its2.item_price,'||
619: 's.new_order_quantity,s.new_processing_days,s.new_schedule_date,s.order_type,'||
620: 'it.planning_make_buy_code,r1.cfm_routing_flag R_CFM_ROUTING_FLAG,it.standard_cost,'||
621: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
622: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
623: 'null PRODUCTION_COST,null PURCHASING_COST,'||
624: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 668: 'it.planning_make_buy_code,r2.cfm_routing_flag R_CFM_ROUTING_FLAG,it.standard_cost,'||

664: 's.source_sr_instance_id,s.source_supplier_id,s.source_supplier_site_id,s.sr_instance_id,'||
665: 'tp.sr_tp_id SR_SUPPLIER_ID,s.supplier_id,s.supplier_site_id,it.bom_item_type,'||
666: 's.disposition_status_type,it.in_source_plan,its1.item_price,'||
667: 's.new_order_quantity,s.new_processing_days,s.new_schedule_date,s.order_type,'||
668: 'it.planning_make_buy_code,r2.cfm_routing_flag R_CFM_ROUTING_FLAG,it.standard_cost,'||
669: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
670: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
671: 'null PRODUCTION_COST,null PURCHASING_COST,'||
672: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 719: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

715: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
716: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
717: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
718: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
719: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
720: 'trunc(inv.detail_date) TIME_DETAIL_DATE_ID,inv.carrying_cost,'||
721: 'inv.detail_date,inv.inventory_cost,inv.mds_cost,inv.mds_price,inv.mds_quantity,'||
722: 'inv.production_cost,inv.purchasing_cost,'||
723: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 753: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

749: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
750: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
751: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
752: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
753: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
754: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
755: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
756: 'null PRODUCTION_COST,null PURCHASING_COST,'||
757: 'decode(org.organization_type,1,res.resource_id/2,2,(res.resource_id-1)/2) RESOURCE_ID,'||

Line 786: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

782: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
783: 'tp.sr_tp_id SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
784: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
785: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
786: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
787: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
788: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
789: 'null PRODUCTION_COST,null PURCHASING_COST,'||
790: 'decode(org.organization_type,1,ex.resource_id/2,2,(ex.resource_id-1)/2) RESOURCE_ID,'||

Line 828: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,it.standard_cost STANDARD_COST,'||

824: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
825: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
826: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
827: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
828: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,it.standard_cost STANDARD_COST,'||
829: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
830: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
831: 'null PRODUCTION_COST,null PURCHASING_COST,'||
832: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 863: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

859: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
860: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
861: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
862: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
863: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
864: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
865: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
866: 'null PRODUCTION_COST,null PURCHASING_COST,'||
867: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 891: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||

887: 'null SOURCE_SR_INSTANCE_ID,null SOURCE_SUPPLIER_ID,null SOURCE_SUPPLIER_SITE_ID,null SR_INSTANCE_ID,'||
888: 'null SR_SUPPLIER_ID,null SUPPLIER_ID,null SUPPLIER_SITE_ID,null BOM_ITEM_TYPE,'||
889: 'null DISPOSITION_STATUS_TYPE,null IN_SOURCE_PLAN,null ITEM_PRICE,'||
890: 'null NEW_ORDER_QUANTITY,null NEW_PROCESSING_DAYS,null NEW_SCHEDULE_DATE,null ORDER_TYPE,'||
891: 'null PLANNING_MAKE_BUY_CODE,null R_CFM_ROUTING_FLAG,null STANDARD_COST,'||
892: 'null TIME_DETAIL_DATE_ID,null CARRYING_COST,'||
893: 'null DETAIL_DATE,null INVENTORY_COST,null MDS_COST,null MDS_PRICE,null MDS_QUANTITY,'||
894: 'null PRODUCTION_COST,null PURCHASING_COST,'||
895: 'null RESOURCE_ID,null DEPARTMENT_ID,'||

Line 1653: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))) PURCHASING_COST,

1649: 6, ent_period_start_date, 5, ent_qtr_start_date, 3, ent_year_start_date) START_DATE,
1650: decode(grouping_id(ent_year_start_date, ent_qtr_start_date, ent_period_start_date),
1651: 6, 32, 5, 64, 3, 128) PERIOD_TYPE_ID,
1652: nvl(ids.sr_supplier_id, -1) SR_SUPPLIER_ID,
1653: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))) PURCHASING_COST,
1654: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate) PURCHASING_COST_G,
1655: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate2) PURCHASING_COST_G1,
1656: ids.uom_code UOM_CODE
1657: FROM isc_dbi_tmp_plans tmp,

Line 1654: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate) PURCHASING_COST_G,

1650: decode(grouping_id(ent_year_start_date, ent_qtr_start_date, ent_period_start_date),
1651: 6, 32, 5, 64, 3, 128) PERIOD_TYPE_ID,
1652: nvl(ids.sr_supplier_id, -1) SR_SUPPLIER_ID,
1653: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))) PURCHASING_COST,
1654: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate) PURCHASING_COST_G,
1655: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate2) PURCHASING_COST_G1,
1656: ids.uom_code UOM_CODE
1657: FROM isc_dbi_tmp_plans tmp,
1658: isc_dbi_supplies_f ids,

Line 1655: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate2) PURCHASING_COST_G1,

1651: 6, 32, 5, 64, 3, 128) PERIOD_TYPE_ID,
1652: nvl(ids.sr_supplier_id, -1) SR_SUPPLIER_ID,
1653: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))) PURCHASING_COST,
1654: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate) PURCHASING_COST_G,
1655: sum(nvl(ids.new_order_quantity,0)*nvl(ids.item_price,nvl(ids.standard_cost,0))*curr.rate2) PURCHASING_COST_G1,
1656: ids.uom_code UOM_CODE
1657: FROM isc_dbi_tmp_plans tmp,
1658: isc_dbi_supplies_f ids,
1659: isc_dbi_plan_curr_rates curr,

Line 1756: avg(nvl(id.standard_cost * id.using_requirement_quantity,0)) COST,

1752: avg(decode(id.origination_type,
1753: 6, nvl(id.selling_price * id.using_requirement_quantity,0),
1754: 30, nvl(id.selling_price * id.using_requirement_quantity,0),
1755: nvl((id.list_price * (100-id.average_discount)/100 * id.using_requirement_quantity),0))) REVENUE,
1756: avg(nvl(id.standard_cost * id.using_requirement_quantity,0)) COST,
1757: sum(1) over (partition by tmp.snapshot_id, id.demand_id) CNT,
1758: sum(decode(reason.reason_type, null, 0, 1)) over (partition by tmp.snapshot_id, id.demand_id) REASON_CNT,
1759: avg(decode(reason.reason_type, null, 0, 1)) LATE_LINES,
1760: id.uom_code

Line 1864: avg(nvl(id.standard_cost * id.using_requirement_quantity,0)) COST,

1860: avg(decode(id.origination_type,
1861: 6, nvl(id.selling_price * id.using_requirement_quantity,0),
1862: 30, nvl(id.selling_price * id.using_requirement_quantity,0),
1863: nvl((id.list_price * (100-id.average_discount)/100 * id.using_requirement_quantity),0))) REVENUE,
1864: avg(nvl(id.standard_cost * id.using_requirement_quantity,0)) COST,
1865: sum(1) over (partition by tmp.snapshot_id, id.demand_id) CNT,
1866: sum(decode(iex.number1, null, 0, 1)) over (partition by tmp.snapshot_id, id.demand_id) REASON_CNT,
1867: avg(CASE WHEN iex.late_lines >= 1 THEN 1 ELSE 0 END) LATE_LINES,
1868: id.uom_code