1. Tables and Views for SCM
  2. MSC_PEGGING_SUPPLY_V

MSC_PEGGING_SUPPLY_V

Details

  • Schema: FUSION

  • Object owner: MSC

  • Object type: VIEW

Columns

Name

SOURCE_TABLE

ROW_ID

TRANSACTION_ID

INVENTORY_ITEM_ID

ORGANIZATION_ID

ORGANIZATION_CODE

PLAN_ORGANIZATION_ID

PLAN_INSTANCE_ID

PLAN_ID

COMPILE_DESIGNATOR

NEW_DUE_DATE

OLD_DUE_DATE

NEW_START_DATE

DISPOSITION_ID

ORDER_NUMBER

DISPOSITION_STATUS_TYPE

ORDER_TYPE

ORDER_TYPE_TEXT

QUANTITY_RATE

OLD_ORDER_QUANTITY

NEW_ORDER_DATE

FIRM_PLANNED_TYPE

RESCHEDULED_FLAG

IMPLEMENTED_QUANTITY

LAST_UNIT_COMPLETION_DATE

NEW_DOCK_DATE

QUANTITY_IN_PROCESS

FIRM_QUANTITY

FIRM_DATE

LINE_ID

IMPLEMENT_DEMAND_CLASS

ITEM_SEGMENTS

IMPLEMENT_DATE

IMPLEMENT_QUANTITY_RATE

IMPLEMENT_FIRM

IMPLEMENT_PROCESSING_DAYS

IMPLEMENT_WIP_CLASS_CODE

IMPLEMENT_JOB_NAME

IMPLEMENT_LINE_ID

IMPLEMENT_STATUS_CODE

IMPLEMENT_LOCATION_ID

RELEASE_STATUS

IMPLEMENT_AS

IMPLEMENT_AS_TEXT

PLANNER_CODE

USING_ASSEMBLY_ITEM_ID

MRP_PLANNING_CODE

REPETITIVE_TYPE

BUILD_IN_WIP_FLAG

PURCHASING_ENABLED_FLAG

PLANNING_MAKE_BUY_CODE

BOM_ITEM_TYPE

BASE_ITEM_ID

WIP_SUPPLY_TYPE

SOURCE_ORGANIZATION_ID

SOURCE_SR_INSTANCE_ID

SOURCE_ORGANIZATION_CODE

STATUS_CODE

USING_ASSEMBLY_SEGMENTS

SOURCE_VENDOR_NAME

SOURCE_VENDOR_SITE_CODE

VENDOR_ID

SUPPLIER_NAME

VENDOR_SITE_ID

SUPPLIER_SITE_CODE

IMPLEMENT_SOURCE_ORG_ID

IMPLEMENT_SR_INSTANCE_ID

IMPLEMENT_VENDOR_ID

IMPLEMENT_VENDOR_SITE_ID

IN_SOURCE_PLAN

SCHEDULE_COMPRESSION_DAYS

PROJECT_ID

TASK_ID

IMPLEMENT_PROJECT_ID

IMPLEMENT_TASK_ID

APPLIED

RELEASE_TIME_FENCE_CODE

IMPLEMENT_SCHEDULE_GROUP_ID

IMPLEMENT_BUILD_SEQUENCE

BUILD_SEQUENCE

SCHEDULE_GROUP_ID

ALTERNATE_BOM_DESIGNATOR

ALTERNATE_ROUTING_DESIGNATOR

PROCESS_SEQ_ID

IMPLEMENT_ALTERNATE_BOM

IMPLEMENT_ALTERNATE_ROUTING

SCHEDULE_GROUP_NAME

IMPLEMENT_EMPLOYEE_ID

CFM_ROUTING_FLAG

BUYER_NAME

RELEASE_ERRORS

UNIT_NUMBER

IMPLEMENT_UNIT_NUMBER

DESCRIPTION

PRODUCT_FAMILY_ID

PRODUCT_FAMILY_NAME

BASE_ITEM_NAME

UOM_CODE

DEMAND_PRIORITY

OVERRIDE_DEMAND_PRIORITY

PROMISE_DATE

REQUEST_DATE

CUSTOMER_ID

CUSTOMER_NAME

CUSTOMER_SITE_ID

CUSTOMER_SITE_NAME

SHIP_TO_SITE_ID

SHIP_TO_SITE_NAME

LOT_NUMBER

SUBINVENTORY_CODE

WIP_STATUS_CODE

WIP_STATUS_TEXT

DMD_SATISFIED_DATE

NEED_BY_DATE

DESIGNATOR_NAME

SELLING_PRICE

DEMAND_CLASS

PROBABILITY

SHIP_DATE

QUANTITY

BUCKET_TYPE

SOURCE_DMD_PRIORITY

RESCHEDULE_DAYS

OLD_NEED_BY_DATE

ORIGINAL_ITEM_ID

ORIGINAL_ITEM_NAME

ORIGINAL_ITEM_QTY

SHIP_METHOD

UNMET_QUANTITY

ORIGINAL_QUANTITY

ORIGINAL_NEED_BY_DATE

EARLIEST_START_DATE

CONSUMPTION_START_DATE

CONTRIBUTES_OVERLOAD

CONTRIBUTES_DMD_LATENESS

SHARED_SUPPLY

USES_ORDER_MODIFIER

PEGGED_TO_FIRM

MATERIAL_AVAIL_DATE

LATEST_START_DATE

RECORD_SOURCE

START_QUANTITY

EXPIRATION_DATE

MRP_PLANNING_CODE_TEXT

ORIGINAL_ORG_ID

ORIGINAL_INST_ID

ORDER_DATE_TYPE_CODE

ORDER_DATE_TYPE_TEXT

SCHEDULE_ARRIVAL_DATE

LATEST_ACCEPTABLE_DATE

PLANNED_ARRIVAL_DATE

SHIPMENT_ID

SHIP_CALENDAR

RECEIVING_CALENDAR

INTRANSIT_CALENDAR

INTRANSIT_LEAD_TIME

IMPLEMENT_DOCK_DATE

IMPLEMENT_SHIP_DATE

IMPLEMENT_ARRIVAL_DATE

REQUEST_SHIP_DATE

PROMISE_SHIP_DATE

LATE_DAYS

SUBSTITUTE_COMPONENT_RANK

SOURCE_TABLE2

SCHEDULE_SHIP_DATE

DEST_ORG_CODE

QTY_BY_DUE_DATE

SHIP_SET_NAME

ARRIVAL_SET_NAME

DEST_ORG_ID

DEST_INST_ID

IMPLEMENT_DEST_ORG_ID

IMPLEMENT_DEST_INST_ID

IMPLEMENT_DEST_ORG_CODE

ZONE

REQUESTED_COMPLETION_DATE

LOTS_EXIST

IMPLEMENT_SHIP_METHOD

ACTUAL_START_DATE

IMPLEMENT_DUE_DATE

SCHEDULE_DESIGNATOR_ID

SALES_ORDER_LINE_ID

SHIP_SET_ID

ARRIVAL_SET_ID

FIRM_START_DATE

BILL_SEQUENCE_ID

ROUTING_SEQUENCE_ID

COMMENTS

PEGGED_DEMAND_ID

ALLOCATED_QUANTITY

PEGGING_ID

PREV_PEGGING_ID

END_PEGGING_ID

START_TRANSACTION_ID

LAST_UPDATE_DATE

LAST_UPDATED_BY

CREATION_DATE

CREATED_BY

LAST_UPDATE_LOGIN

LOAD_TYPE

BASE_PLAN_ID

ROUNDING_CONTROL_TYPE

OLD_DOCK_DATE

PLAN_CUTOFF_DATE

PLAN_START_DATE

RESERVED_QUANTITY

CTB_FLAG

CTB_COMP_AVAIL_PERCENT

RTB_ORDER_QTY_PERCENT

CTB_EXPECTED_DATE

CTB_PRIORITY

REVISED_DMD_DATE

REVISED_DMD_PRIORITY

SHIP_METHOD_TEXT

ORIG_FIRM_DATE

ORIG_FIRM_QUANTITY

SO_LINE_NUM

ORCH_ORDER_NUMBER

ORCH_ORDER_LINE_NUMBER

FULFILLMENT_LINE_NUM

PEGGING_TYPE

BMT_FLAG

DROP_SHIP_DEST_TYPE

RELEASE_ACTION

BACK_TO_BACK_FLAG

DEMAND_CLASS_CODE

NET_SUPPLY_QTY_OVERRIDE

IMPLEMENT_BILL_SEQUENCE_ID

IMPLEMENT_ROUTING_SEQUENCE_ID

CARRIER_ID

MODE_OF_TRANSPORT

SERVICE_LEVEL

IMPLEMENT_CARRIER_ID

IMPLEMENT_MODE_OF_TRANSPORT

IMPLEMENT_SERVICE_LEVEL

IMPLEMENT_SHIP_METHOD_TEXT

CUSTOMER_PO_NUMBER

ITEM_STRUCTURE_NAME

WORK_DEFINITION

IMPLEMENT_ITEM_STRUCTURE

IMPLEMENT_WORK_DEFINITION

DAYS_PAST_DUE

QTY_SATISFIED_BY_RDD

EXPENSE_TRANSFER

PARENT_MODEL_ITEM_ID

PARENT_MODEL_ITEM

QTY_COMPLETED

QTY_SCRAPPED

EXPECTED_SCRAP_QTY

FIRM_START_QUANTITY

TIMEZONE_NAME

TIMEZONE_CODE

SOURCE_TIMEZONE_NAME

SOURCE_TIMEZONE_CODE

DESTINATION_TIMEZONE_NAME

DESTINATION_TIMEZONE_CODE

OPERATION_SEQ_NUM

ALT_FACILITY_USED

ALT_SUPPLIER_USED

ALT_WORK_DEFINITION_USED

ALT_RESOURCE_USED

SUBSTITUTE_COMPONENT_USED

CANCELED

TOTAL_OUTPUT_QUANTITY

LAST_OP_COMPLETION_DATE

WORK_METHOD_CODE

PROCESS_NAME

BATCH_UOM

WORK_ORDER_SUB_TYPE

HARD_PEGGING_LEVEL

GLOBAL_ATTRIBUTE_NUMBER11

GLOBAL_ATTRIBUTE_NUMBER12

GLOBAL_ATTRIBUTE_NUMBER13

GLOBAL_ATTRIBUTE_NUMBER14

GLOBAL_ATTRIBUTE_NUMBER15

GLOBAL_ATTRIBUTE_NUMBER16

GLOBAL_ATTRIBUTE_NUMBER17

GLOBAL_ATTRIBUTE_NUMBER18

GLOBAL_ATTRIBUTE_NUMBER19

GLOBAL_ATTRIBUTE_NUMBER20

GLOBAL_ATTRIBUTE_NUMBER21

GLOBAL_ATTRIBUTE_NUMBER22

GLOBAL_ATTRIBUTE_NUMBER23

GLOBAL_ATTRIBUTE_NUMBER24

GLOBAL_ATTRIBUTE_NUMBER25

GLOBAL_ATTRIBUTE_NUMBER26

GLOBAL_ATTRIBUTE_NUMBER27

GLOBAL_ATTRIBUTE_NUMBER28

GLOBAL_ATTRIBUTE_NUMBER29

GLOBAL_ATTRIBUTE_NUMBER30

GLOBAL_ATTRIBUTE_NUMBER31

GLOBAL_ATTRIBUTE_NUMBER32

GLOBAL_ATTRIBUTE_NUMBER33

GLOBAL_ATTRIBUTE_NUMBER34

GLOBAL_ATTRIBUTE_NUMBER35

GLOBAL_ATTRIBUTE_NUMBER36

GLOBAL_ATTRIBUTE_NUMBER37

GLOBAL_ATTRIBUTE_NUMBER38

GLOBAL_ATTRIBUTE_NUMBER39

GLOBAL_ATTRIBUTE_NUMBER40

IMPLEMENT_SOURCE_ORG

IMPLEMENT_SUPPLIER

IMPLEMENT_SUPPLIER_SITE

ORG_CURRENCY_CODE

QTY_REMAINING

PLANNER_DESCRIPTION

ASSET_NUMBER

SEGMENT_ID

SEGMENT_NAME

NET_SEQ_NUM

ORIGINAL_TRANSACTION_ID

HOLD_DATE

ORDER_STATUS

IMPLEMENT_LOCATION_CODE

CHILD_ORGANIZATION_ID

CHILD_ORGANIZATION_CODE

ORIGINAL_SUBINVENTORY_CODE

ATTRIBUTE_ROW_ID

FG_ORDER_TYPE

MATURITY_DATE

CONSTRAINED_START_DATE

CUMULATIVE_YIELD

MTQ_SUPPLY_DATE

Query

SQL_Statement

SELECT /*+ORDERED index(sup,MSC_SUPPLIES_U1) */

'MSC_SUPPLIES' SOURCE_TABLE,

sup.ROWID ROW_ID,

mfp.TRANSACTION_ID,

sup.INVENTORY_ITEM_ID,

sup.ORGANIZATION_ID,

msi.organization_code,

to_number(NULL) PLAN_ORGANIZATION_ID,

to_number(NULL) PLAN_INSTANCE_ID,

mfp.plan_id,

mp.compile_designator,

sup.NEW_SCHEDULE_DATE NEW_DUE_DATE,

sup.OLD_SCHEDULE_DATE OLD_DUE_DATE,

sup.NEW_WIP_START_DATE NEW_START_DATE,

sup.DISPOSITION_ID,

msc_get_name.supply_order_number_new (sup.order_type, sup.order_number, sup.transaction_id, sup.disposition_id, sup.fg_order_type) ORDER_NUMBER,

sup.DISPOSITION_STATUS_TYPE,

sup.ORDER_TYPE,

(select msc_get_name.lookup_meaning('MSC_ORDER_TYPE', sup.ORDER_TYPE) from dual) ORDER_TYPE_TEXT,

NVL(sup.daily_rate,sup.NEW_ORDER_QUANTITY) QUANTITY_RATE,

sup.OLD_ORDER_QUANTITY,

NVL(sup.NEW_ORDER_PLACEMENT_DATE, sup.firm_date) NEW_ORDER_DATE,

sup.FIRM_PLANNED_TYPE,

sup.RESCHEDULE_FLAG RESCHEDULED_FLAG,

sup.IMPLEMENTED_QUANTITY,

sup.LAST_UNIT_COMPLETION_DATE,

sup.NEW_DOCK_DATE,

sup.QUANTITY_IN_PROCESS,

sup.FIRM_QUANTITY,

sup.FIRM_DATE,

sup.LINE_ID,

sup.IMPLEMENT_DEMAND_CLASS,

msi.item_name ITEM_SEGMENTS,

sup.IMPLEMENT_DATE,

NVL(sup.implement_daily_rate,sup.IMPLEMENT_QUANTITY) IMPLEMENT_QUANTITY_RATE,

sup.IMPLEMENT_FIRM,

TO_NUMBER(NULL) IMPLEMENT_PROCESSING_DAYS,

sup.IMPLEMENT_WIP_CLASS_CODE,

sup.IMPLEMENT_JOB_NAME,

TO_NUMBER(NULL) IMPLEMENT_LINE_ID,

sup.IMPLEMENT_STATUS_CODE,

sup.IMPLEMENT_LOCATION_ID,

sup.RELEASE_STATUS,

sup.IMPLEMENT_AS,

DECODE(sup.implement_as, NULL, NULL, (select msc_get_name.lookup_meaning('ORA_MSC_WORKBENCH_IMPLEMENT_AS',sup.implement_as) from dual)) IMPLEMENT_AS_TEXT,

msi.PLANNER_CODE,

to_number(NULL) USING_ASSEMBLY_ITEM_ID,

msi.MRP_PLANNING_CODE,

NULL REPETITIVE_TYPE,

msi.BUILD_IN_WIP_FLAG,

msi.PURCHASING_ENABLED_FLAG,

msi.PLANNING_MAKE_BUY_CODE,

msi.BOM_ITEM_TYPE,

msi.BASE_ITEM_ID,

msi.WIP_SUPPLY_TYPE,

sup.SOURCE_ORGANIZATION_ID,

NULL SOURCE_SR_INSTANCE_ID,

decode(sup.source_organization_id, NULL, NULL, (select msc_get_name.org_code(sup.source_organization_id) from dual)) SOURCE_ORGANIZATION_CODE,

sup.wip_status_code STATUS_CODE,

NULL USING_ASSEMBLY_SEGMENTS,

decode(sup.supplier_id, NULL, NULL,(select msc_get_name.supplier(sup.supplier_id) from dual)) SOURCE_VENDOR_NAME,

decode(sup.supplier_site_id, NULL, NULL,(select msc_get_name.supplier_site(sup.supplier_site_id) from dual)) SOURCE_VENDOR_SITE_CODE,

sup.supplier_id VENDOR_ID,

NULL SUPPLIER_NAME,

sup.supplier_site_id VENDOR_SITE_ID,

NULL SUPPLIER_SITE_CODE,

sup.IMPLEMENT_SOURCE_ORG_ID,

NULL IMPLEMENT_SR_INSTANCE_ID,

sup.implement_supplier_id IMPLEMENT_VENDOR_ID,

sup.implement_supplier_site_id IMPLEMENT_VENDOR_SITE_ID,

2 IN_SOURCE_PLAN,

sup.schedule_compress_days SCHEDULE_COMPRESSION_DAYS,

sup.project_id,

sup.task_id,

sup.implement_project_id,

sup.implement_task_id ,

sup.applied,

msi.release_time_fence_code,

sup.implement_schedule_group_id,

sup.implement_build_sequence,

DECODE(sup.ORDER_TYPE, 3, sup.BUILD_SEQUENCE, 7, sup.BUILD_SEQUENCE, 14, sup.BUILD_SEQUENCE, 15, sup.BUILD_SEQUENCE, 27, sup.BUILD_SEQUENCE, to_number( NULL)) BUILD_SEQUENCE,

DECODE(sup.ORDER_TYPE, 3, sup.SCHEDULE_GROUP_ID, 7, sup.SCHEDULE_GROUP_ID, 14, sup.SCHEDULE_GROUP_ID, 15, sup.SCHEDULE_GROUP_ID, 27, sup.SCHEDULE_GROUP_ID, to_number(NULL)) SCHEDULE_GROUP_ID,

sup.alternate_bom_designator,

sup.alternate_routing_designator,

sup.process_seq_id,

sup.implement_alternate_bom,

sup.implement_alternate_routing,

sup.schedule_group_name,

sup.implement_employee_id,

to_number(NULL) CFM_ROUTING_FLAG,

msi.BUYER_NAME,

sup.release_errors,

sup.unit_number,

sup.implement_unit_number,

msi.description,

msi.product_family_id,

decode(msi.product_family_id, NULL, NULL, (select msc_get_name.item_name(msi.product_family_id,NULL,NULL) from dual)) PRODUCT_FAMILY_NAME,

NULL BASE_ITEM_NAME,

msi.uom_code,

DECODE(mp.plan_type, 5, to_number(NULL), sup.schedule_priority) DEMAND_PRIORITY,

to_number(NULL) OVERRIDE_DEMAND_PRIORITY,

sup.promised_date PROMISE_DATE,

decode(sup.order_type, 1, sup.original_need_by_date, 2, sup.original_need_by_date, to_date(null)) REQUEST_DATE,

sup.drop_ship_cust_id CUSTOMER_ID,

decode(sup.drop_ship_cust_id, NULL, NULL, (select msc_get_name.customer(sup.drop_ship_cust_id) from dual)) CUSTOMER_NAME,

sup.drop_ship_cust_site_id CUSTOMER_SITE_ID,

decode(sup.drop_ship_cust_site_id, NULL, NULL, (select msc_get_name.customer_site( sup.drop_ship_cust_site_id) from dual)) CUSTOMER_SITE_NAME,

to_number(NULL) SHIP_TO_SITE_ID,

NULL SHIP_TO_SITE_NAME,

sup.lot_number,

sup.subinventory_code,

sup.wip_status_code,

decode(sup.wip_status_code, NULL, NULL, (select msc_get_name.lookup_meaning('ORA_MSC_WIP_JOB_STATUS', sup.wip_status_code) from dual)) WIP_STATUS_TEXT,

to_date(NULL) DMD_SATISFIED_DATE,

sup.need_by_date,

NVL(sup.schedule_designator, (select msc_get_name.designator(sup.schedule_designator_id, null, sup.plan_id) from dual)) DESIGNATOR_NAME,

to_number(NULL) SELLING_PRICE,

DECODE(sup.demand_class ,'-1', NULL, sup.demand_class) DEMAND_CLASS,

to_number(NULL) PROBABILITY,

sup.new_ship_date SHIP_DATE,

sup.new_order_quantity QUANTITY,

NULL BUCKET_TYPE,

to_number(NULL) SOURCE_DMD_PRIORITY,

sup.reschedule_days,

DECODE(sup.plan_id, -1, sup.new_dock_date, sup.old_need_by_date) OLD_NEED_BY_DATE,

to_number(NULL) ORIGINAL_ITEM_ID,

NULL ORIGINAL_ITEM_NAME,

to_number(NULL) ORIGINAL_ITEM_QTY,

sup.ship_method,

to_number(NULL) UNMET_QUANTITY,

sup.original_quantity,

sup.original_need_by_date,

sup.earliest_start_date,

sup.Consumption_Start_Date,

sup.Contributes_Overload,

sup.Contributes_dmd_lateness,

sup.Shared_Supply,

sup.Uses_Order_Modifier,

sup.Pegged_to_Firm,

sup.Material_Avail_Date,

sup.Latest_Start_Date,

sup.record_source,

sup.start_quantity,

sup.expiration_date,

(select msc_get_name.lookup_meaning('ORA_MSC_PLANNING_CODE',msi.mrp_planning_code) from dual) MRP_PLANNING_CODE_TEXT,

to_number(NULL) ORIGINAL_ORG_ID,

to_number(NULL) ORIGINAL_INST_ID,

to_number(NULL) ORDER_DATE_TYPE_CODE,

TO_CHAR(NULL) ORDER_DATE_TYPE_TEXT,

to_date(NULL) SCHEDULE_ARRIVAL_DATE,

to_date(NULL) LATEST_ACCEPTABLE_DATE,

to_date(NULL) PLANNED_ARRIVAL_DATE,

sup.shipment_id,

sup.ship_calendar,

sup.receiving_calendar,

sup.intransit_calendar,

sup.intransit_lead_time,

sup.implement_dock_date,

sup.implement_ship_date,

to_date(NULL) IMPLEMENT_ARRIVAL_DATE,

decode(sup.order_type, 1, sup.requested_ship_date, 2, sup.requested_ship_date, to_date(null)) REQUEST_SHIP_DATE,

decode(sup.order_type, 1, sup.promised_ship_date, 2, sup.promised_ship_date, to_date(null)) PROMISE_SHIP_DATE,

sup.days_late LATE_DAYS,

to_number(NULL) SUBSTITUTE_COMPONENT_RANK,

'MSC_SUPPLIES' SOURCE_TABLE2,

to_date(NULL) SCHEDULE_SHIP_DATE,

NULL DEST_ORG_CODE,

to_number(NULL) QTY_BY_DUE_DATE,

NULL SHIP_SET_NAME,

NULL ARRIVAL_SET_NAME,

to_number(NULL) DEST_ORG_ID,

to_number(NULL) DEST_INST_ID,

to_number(NULL) IMPLEMENT_DEST_ORG_ID,

to_number(NULL) IMPLEMENT_DEST_INST_ID,

NULL IMPLEMENT_DEST_ORG_CODE,

decode(sup.zone_id, NULL, NULL, (select msc_get_name.get_zone_name(sup.zone_id) from dual)) ZONE,

sup.requested_completion_date,

NULL LOTS_EXIST,

sup.implement_ship_method,

sup.actual_start_date,

to_date(NULL) IMPLEMENT_DUE_DATE,

to_number(NULL) SCHEDULE_DESIGNATOR_ID,

to_number(NULL) sales_order_line_id ,

to_number(NULL) ship_set_id ,

to_number(NULL) arrival_set_id ,

sup.firm_start_date,

sup.bill_sequence_id,

sup.routing_sequence_id,

NULL COMMENTS,

mfp.demand_id pegged_demand_id,

mfp.allocated_quantity,

mfp.pegging_id,

mfp.prev_pegging_id,

mfp.end_pegging_id,

mfp.dest_transaction_id start_transaction_id,

sup.LAST_UPDATE_DATE,

sup.LAST_UPDATED_BY,

sup.CREATION_DATE,

sup.CREATED_BY,

sup.LAST_UPDATE_LOGIN,

sup.load_type,

msi.plan_id base_plan_id,

msi.rounding_control_type,

sup.OLD_DOCK_DATE,

NULL plan_cutoff_date,

NULL plan_start_date,

sup.reserved_quantity,

sup.CTB_FLAG,

sup.CTB_COMP_AVAIL_PERCENT,

sup.RTB_ORDER_QTY_PERCENT,

sup.CTB_EXPECTED_DATE,

sup.CTB_PRIOIRTY CTB_PRIORITY,

to_date(NULL) revised_dmd_date,

to_number(NULL) revised_dmd_priority,

nvl(sup.ship_method, (select msc_get_name.get_ship_method(sup.carrier_id, sup.mode_of_transport, sup.service_level) from dual)) ship_method_text,

sup.ORIG_FIRM_DATE,

sup.ORIG_FIRM_QUANTITY,

to_char(null) SO_LINE_NUM,

to_char(null) ORCH_ORDER_NUMBER,

msc_get_name.supply_order_line_number(sup.order_type, sup.fg_order_type, sup.purch_line_num, sup.to_line_number) ORCH_ORDER_LINE_NUMBER,

to_number(null) FULFILLMENT_LINE_NUM,

mfp.PEGGING_TYPE,

sup.BMT_FLAG,

sup.DROP_SHIP_DEST_TYPE,

MSC_SPUI_COMMON.release_action('MSC_SUPPLIES',sup.plan_id,sup.ORGANIZATION_ID,sup.INVENTORY_ITEM_ID,sup.ORDER_TYPE,sup.TRANSACTION_ID,msi.PURCHASING_ENABLED_FLAG,nvl(sup.RESCHEDULE_FLAG,2),nvl(sup.reschedule_days,0),msi.release_time_fence_code,msi.BUILD_IN_WIP_FLAG,sup.SOURCE_ORGANIZATION_ID,sup.new_order_quantity,sup.FIRM_QUANTITY,sup.RELEASE_STATUS,msi.wip_supply_type,msi.BOM_ITEM_TYPE,msi.PLANNING_MAKE_BUY_CODE,null,sup.original_quantity,sup.DISPOSITION_STATUS_TYPE,sup.reserved_quantity,sup.routing_sequence_id,msi.PLANNER_CODE,sup.FIRM_PLANNED_TYPE,sup.applied,sup.drop_ship_dest_type,msi.back_to_back_flag,msi.in_source_plan,sup.fg_order_type,sup.allow_tol_cancel_release,sup.release_errors) release_action,

msi.back_to_back_flag,

decode(sup.demand_class, NULL, NULL, (select msc_get_name.msc_sr_lookup_meaning(sup.demand_class, 'DEMAND_CLASS') from dual)) DEMAND_CLASS_CODE,

sup.net_supply_qty_override,

sup.implement_bill_sequence_id,

sup.implement_routing_sequence_id,

sup.carrier_id,

sup.mode_of_transport,

sup.service_level,

sup.implement_carrier_id,

sup.implement_mode_of_transport_id IMPLEMENT_MODE_OF_TRANSPORT,

sup.implement_service_level_id IMPLEMENT_SERVICE_LEVEL,

nvl(sup.implement_ship_method, (select msc_get_name.get_ship_method(sup.implement_carrier_id, sup.implement_mode_of_transport_id, sup.implement_service_level_id) from dual)) IMPLEMENT_SHIP_METHOD_TEXT,

to_char(null) CUSTOMER_PO_NUMBER,

decode(sup.bill_sequence_id, NULL, NULL, (select msc_get_name.get_item_structure_name(msi.plan_id, sup.bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) ITEM_STRUCTURE_NAME,

CASE

WHEN (sup.routing_sequence_id IS NULL AND sup.bill_sequence_id IS NULL ) THEN NULL

WHEN (sup.routing_sequence_id IS NULL AND sup.bill_sequence_id IS NOT NULL ) THEN 'NotAvailable'

ELSE (select msc_get_name.get_work_definition(msi.plan_id,

sup.routing_sequence_id,

sup.organization_id,

msi.SIMULATION_SET_ID) from dual)

END WORK_DEFINITION,

decode(sup.implement_bill_sequence_id, NULL, NULL, (select msc_get_name.get_item_structure_name(msi.plan_id, sup.implement_bill_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) IMPLEMENT_ITEM_STRUCTURE,

decode(sup.implement_routing_sequence_id, NULL, NULL, (select msc_get_name.get_work_definition(msi.plan_id, sup.implement_routing_sequence_id,sup.organization_id,msi.SIMULATION_SET_ID) from dual)) IMPLEMENT_WORK_DEFINITION,

sup.days_past_due,

to_number(null) QTY_SATISFIED_BY_RDD,

2 EXPENSE_TRANSFER,

to_number(null) PARENT_MODEL_ITEM_ID,

to_char(null) PARENT_MODEL_ITEM,

SUP.QTY_COMPLETED,

SUP.QTY_SCRAPPED,

SUP.EXPECTED_SCRAP_QTY,

SUP.FIRM_START_QUANTITY,

(select msc_get_name.get_timezone_name(SUP.ORGANIZATION_ID) from dual) TIMEZONE_NAME,

(select msc_get_name.get_timezone_code(SUP.ORGANIZATION_ID) from dual) TIMEZONE_CODE,

(select msc_get_name.get_source_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_NAME,

(select msc_get_name.get_source_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.supplier_site_id) from dual) SOURCE_TIMEZONE_CODE,

(select msc_get_name.get_destination_timezone_name(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_NAME,

(select msc_get_name.get_destination_timezone_code(sup.order_type, sup.organization_id, sup.source_organization_id, sup.drop_ship_cust_site_id) from dual) DESTINATION_TIMEZONE_CODE,

sup.operation_seq_num,

sup.alt_facility_used,

sup.alt_supplier_used,

sup.alt_work_definition_used,

sup.alt_resource_used,

sup.substitute_component_used,

decode(sup.disposition_status_type, 1,2,2,1,null) CANCELED,

sup.total_output_quantity,

sup.last_op_completion_date,

NVL(sup.WORK_METHOD_CODE, 1) WORK_METHOD_CODE,

sup.process_name,

decode(sup.UOM_CODE, NULL, NULL, (select msc_get_name.get_unit_of_measure(sup.UOM_CODE) from dual)) BATCH_UOM,

sup.work_order_sub_type,

msi.hard_pegging_level,

sup.GLOBAL_ATTRIBUTE_NUMBER11,

sup.GLOBAL_ATTRIBUTE_NUMBER12,

sup.GLOBAL_ATTRIBUTE_NUMBER13,

sup.GLOBAL_ATTRIBUTE_NUMBER14,

sup.GLOBAL_ATTRIBUTE_NUMBER15,

sup.GLOBAL_ATTRIBUTE_NUMBER16,

sup.GLOBAL_ATTRIBUTE_NUMBER17,

sup.GLOBAL_ATTRIBUTE_NUMBER18,

sup.GLOBAL_ATTRIBUTE_NUMBER19,

sup.GLOBAL_ATTRIBUTE_NUMBER20,

sup.GLOBAL_ATTRIBUTE_NUMBER21,

sup.GLOBAL_ATTRIBUTE_NUMBER22,

sup.GLOBAL_ATTRIBUTE_NUMBER23,

sup.GLOBAL_ATTRIBUTE_NUMBER24,

sup.GLOBAL_ATTRIBUTE_NUMBER25,

sup.GLOBAL_ATTRIBUTE_NUMBER26,

sup.GLOBAL_ATTRIBUTE_NUMBER27,

sup.GLOBAL_ATTRIBUTE_NUMBER28,

sup.GLOBAL_ATTRIBUTE_NUMBER29,

sup.GLOBAL_ATTRIBUTE_NUMBER30,

sup.GLOBAL_ATTRIBUTE_NUMBER31,

sup.GLOBAL_ATTRIBUTE_NUMBER32,

sup.GLOBAL_ATTRIBUTE_NUMBER33,

sup.GLOBAL_ATTRIBUTE_NUMBER34,

sup.GLOBAL_ATTRIBUTE_NUMBER35,

sup.GLOBAL_ATTRIBUTE_NUMBER36,

sup.GLOBAL_ATTRIBUTE_NUMBER37,

sup.GLOBAL_ATTRIBUTE_NUMBER38,

sup.GLOBAL_ATTRIBUTE_NUMBER39,

sup.GLOBAL_ATTRIBUTE_NUMBER40,

decode(sup.IMPLEMENT_SOURCE_ORG_ID, NULL, NULL, (select msc_get_name.org_code(sup.IMPLEMENT_SOURCE_ORG_ID) from dual)) implement_source_org,

decode(sup.IMPLEMENT_SUPPLIER_ID, NULL, NULL, (select msc_get_name.supplier(sup.IMPLEMENT_SUPPLIER_ID) from dual)) implement_supplier,

decode(sup.IMPLEMENT_SUPPLIER_SITE_ID, NULL, NULL, (select msc_get_name.supplier_site(sup.IMPLEMENT_SUPPLIER_SITE_ID) from dual)) implement_supplier_site,

to_char(null) ORG_CURRENCY_CODE,

nvl(sup.start_quantity,0)-nvl(sup.qty_completed,0)-nvl(sup.qty_scrapped,0) QTY_REMAINING,

decode(msi.PLANNER_CODE, NULL, NULL, (select msc_get_name.get_planner_desc(msi.PLANNER_CODE) from dual)) PLANNER_DESCRIPTION,

sup.asset_number,

msi.segment_id,

decode(msi.segment_id, NULL, NULL, (select msc_get_name.segment_name(msi.segment_id) from dual)) SEGMENT_NAME,

mfp.net_seq_num,

to_number(null) original_transaction_id,

sup.hold_date HOLD_DATE,

case when sup.order_type in (3) then sup.wip_status_code * 10000

when sup.order_type in (1,3,94) then sup.order_status

else null end order_status,

decode(sup.implement_location_id, null, null, (select msc_get_name.get_location_code(sup.implement_location_id, sup.organization_id) from dual)) implement_location_code,

sup.child_organization_id,

decode(sup.child_organization_id, NULL, NULL, (select msc_get_name.org_code(sup.child_organization_id) from dual)) child_organization_code,

sup.original_subinventory_code,

sup.ATTRIBUTE_ROW_ID,

sup.fg_order_type,

sup.maturity_date,

sup.constrained_start_date,

sup.cumulative_yield,

sup.mtq_supply_date

FROM

msc_full_pegging mfp,

msc_plan_definitions mp,

MSC_SUPPLIES SUP,

msc_system_items msi

WHERE

mfp.plan_id = mp.plan_id

AND mfp.plan_id = sup.plan_id

AND mfp.transaction_id = sup.transaction_id

and sup.base_plan_id = msi.plan_id

AND sup.ORGANIZATION_ID = msi.ORGANIZATION_ID

AND sup.INVENTORY_ITEM_ID = msi.INVENTORY_ITEM_ID

AND (msi.new_plan_id = -1)

AND (msi.SIMULATION_SET_ID = -1)