VIEW: APPS.MSC_EAM_CMRO_SUPPLIES_V

Source

View Text - Preformatted

SELECT orgs.plan_id, sup.inventory_item_id, sup.activity_item_id, sup.organization_id, sup.sr_instance_id, sup.transaction_id, decode(sup.order_type, 92, sup.new_schedule_date, decode(sup.maintenance_object_source, 2, decode( sup.schedule_designator_id, null, sup.new_schedule_date, sup.new_wip_start_date), sup.new_schedule_date)), sup.order_type, sup.maintenance_object_source, sup.schedule_designator_id, sup.demand_class, sup.disposition_id, sup.new_order_quantity, sup.wip_start_quantity, sup.expected_scrap_qty, sup.qty_scrapped, sup.qty_completed, sup.new_wip_start_date, sup.firm_planned_type, sup.revision, sup.project_id, sup.task_id, sup.planning_group, sup.schedule_group_id, sup.schedule_group_name, sup.build_sequence, sup.line_id, sup.bill_sequence_id, sup.routing_sequence_id, sup.unit_number, sup.process_seq_id, sup.by_product_using_assy_id, sup.order_number, sup.wip_status_code, sup.coproducts_supply, sup.operation_seq_num, sup.jump_op_seq_num, sup.job_op_seq_num, sup.quantity_per_assembly, sup.quantity_issued, sup.wsm_faulty_network, sup.requested_start_date, sup.requested_completion_date, sup.schedule_priority, sup.asset_item_id, sup.asset_serial_number, sup.actual_start_date, sup.item_type_value, sup.activity_type, sup.class_code, sup.shutdown_type, sup.to_be_exploded, sup.object_type, sup.maintenance_type_code, sup.top_transaction_id, sup.description, sup.produces_to_stock, sup.product_classification, sup.maintenance_requirement from msc_supplies sup, msc_plan_schedules sch, msc_plan_organizations orgs where sup.plan_id = -1 and orgs.plan_id = sch.plan_id and sup.sr_instance_id = orgs.sr_instance_id and sup.organization_id = orgs.organization_id and sup.order_type in (70,92) and ((sch.designator_type = 12 and sup.maintenance_object_source = 1 and ((sch.input_schedule_id = sup.schedule_designator_id and sch.sr_instance_id = sup.sr_instance_id ) OR (sch.input_schedule_id = -1001 and sup.schedule_designator_id IS NULL))) OR (sch.designator_type = 13 and sup.maintenance_object_source = 2 and ((sch.input_schedule_id = sup.schedule_designator_id and sch.sr_instance_id = sup.sr_instance_id ) OR (sch.input_schedule_id = -1002 and sup.schedule_designator_id IS NULL))))

View Text - HTML Formatted

SELECT ORGS.PLAN_ID
, SUP.INVENTORY_ITEM_ID
, SUP.ACTIVITY_ITEM_ID
, SUP.ORGANIZATION_ID
, SUP.SR_INSTANCE_ID
, SUP.TRANSACTION_ID
, DECODE(SUP.ORDER_TYPE
, 92
, SUP.NEW_SCHEDULE_DATE
, DECODE(SUP.MAINTENANCE_OBJECT_SOURCE
, 2
, DECODE( SUP.SCHEDULE_DESIGNATOR_ID
, NULL
, SUP.NEW_SCHEDULE_DATE
, SUP.NEW_WIP_START_DATE)
, SUP.NEW_SCHEDULE_DATE))
, SUP.ORDER_TYPE
, SUP.MAINTENANCE_OBJECT_SOURCE
, SUP.SCHEDULE_DESIGNATOR_ID
, SUP.DEMAND_CLASS
, SUP.DISPOSITION_ID
, SUP.NEW_ORDER_QUANTITY
, SUP.WIP_START_QUANTITY
, SUP.EXPECTED_SCRAP_QTY
, SUP.QTY_SCRAPPED
, SUP.QTY_COMPLETED
, SUP.NEW_WIP_START_DATE
, SUP.FIRM_PLANNED_TYPE
, SUP.REVISION
, SUP.PROJECT_ID
, SUP.TASK_ID
, SUP.PLANNING_GROUP
, SUP.SCHEDULE_GROUP_ID
, SUP.SCHEDULE_GROUP_NAME
, SUP.BUILD_SEQUENCE
, SUP.LINE_ID
, SUP.BILL_SEQUENCE_ID
, SUP.ROUTING_SEQUENCE_ID
, SUP.UNIT_NUMBER
, SUP.PROCESS_SEQ_ID
, SUP.BY_PRODUCT_USING_ASSY_ID
, SUP.ORDER_NUMBER
, SUP.WIP_STATUS_CODE
, SUP.COPRODUCTS_SUPPLY
, SUP.OPERATION_SEQ_NUM
, SUP.JUMP_OP_SEQ_NUM
, SUP.JOB_OP_SEQ_NUM
, SUP.QUANTITY_PER_ASSEMBLY
, SUP.QUANTITY_ISSUED
, SUP.WSM_FAULTY_NETWORK
, SUP.REQUESTED_START_DATE
, SUP.REQUESTED_COMPLETION_DATE
, SUP.SCHEDULE_PRIORITY
, SUP.ASSET_ITEM_ID
, SUP.ASSET_SERIAL_NUMBER
, SUP.ACTUAL_START_DATE
, SUP.ITEM_TYPE_VALUE
, SUP.ACTIVITY_TYPE
, SUP.CLASS_CODE
, SUP.SHUTDOWN_TYPE
, SUP.TO_BE_EXPLODED
, SUP.OBJECT_TYPE
, SUP.MAINTENANCE_TYPE_CODE
, SUP.TOP_TRANSACTION_ID
, SUP.DESCRIPTION
, SUP.PRODUCES_TO_STOCK
, SUP.PRODUCT_CLASSIFICATION
, SUP.MAINTENANCE_REQUIREMENT
FROM MSC_SUPPLIES SUP
, MSC_PLAN_SCHEDULES SCH
, MSC_PLAN_ORGANIZATIONS ORGS
WHERE SUP.PLAN_ID = -1
AND ORGS.PLAN_ID = SCH.PLAN_ID
AND SUP.SR_INSTANCE_ID = ORGS.SR_INSTANCE_ID
AND SUP.ORGANIZATION_ID = ORGS.ORGANIZATION_ID
AND SUP.ORDER_TYPE IN (70
, 92)
AND ((SCH.DESIGNATOR_TYPE = 12
AND SUP.MAINTENANCE_OBJECT_SOURCE = 1
AND ((SCH.INPUT_SCHEDULE_ID = SUP.SCHEDULE_DESIGNATOR_ID
AND SCH.SR_INSTANCE_ID = SUP.SR_INSTANCE_ID ) OR (SCH.INPUT_SCHEDULE_ID = -1001
AND SUP.SCHEDULE_DESIGNATOR_ID IS NULL))) OR (SCH.DESIGNATOR_TYPE = 13
AND SUP.MAINTENANCE_OBJECT_SOURCE = 2
AND ((SCH.INPUT_SCHEDULE_ID = SUP.SCHEDULE_DESIGNATOR_ID
AND SCH.SR_INSTANCE_ID = SUP.SR_INSTANCE_ID ) OR (SCH.INPUT_SCHEDULE_ID = -1002
AND SUP.SCHEDULE_DESIGNATOR_ID IS NULL))))