MSC_ATP_HVGOP_SUPPLIES_V

Details

• Schema: FUSION

• Object owner: MSC

• Object type: VIEW

Columns

Name
ORDER_TYPE TRANSACTION_ID ORDER_NUMBER INVENTORY_ITEM_ID ORGANIZATION_ID NEW_ORDER_QUANTITY OLD_QUANTITY SUPPLIER_ID SUPPLIER_SITE_ID DROP_SHIP_CUST_ID DROP_SHIP_CUST_SITE_ID DOCK_DATE SCHEDULE_DATE SHIP_DATE OLD_SUPPLY_DATE SHIP_METHOD SOURCE_ORGANIZATION_ID ROUTING_SEQUENCE_ID BILL_SEQUENCE_ID DISPOSITION_ID REFRESH_NUMBER PLAN_ID FULFILL_ORCHESTRATION_REQUIRED FG_ORDER_TYPE

Query

SQL_Statement

SELECT sup.order_type order_type, sup.transaction_id transaction_id, sup.order_number order_number, sup.inventory_item_id inventory_item_id, sup.organization_id organization_id, sup.new_order_quantity new_order_quantity, (select sup_det.quantity from msc_hvgop_supply_details sup_det where sup_det.transaction_id = sup.transaction_id) old_quantity, sup.supplier_id supplier_id, sup.supplier_site_id supplier_site_id, sup.drop_ship_cust_id drop_ship_cust_id, sup.drop_ship_cust_site_id drop_ship_cust_site_id, nvl(sup.new_dock_date,nvl(sup.new_ship_date,sup.new_schedule_date)) dock_date, sup.new_schedule_date schedule_date, nvl(sup.new_ship_date,sup.new_schedule_date) ship_date, (select availability_date from msc_hvgop_supply_details sup_det where sup_det.transaction_id = sup.transaction_id) old_supply_date, decode(sup.carrier_id || ':' ||sup.mode_of_transport || ':' ||sup.service_level,'::',to_char(null),sup.carrier_id || ':' ||sup.mode_of_transport || ':' || sup.service_level) as ship_method , sup.source_organization_id source_organization_id, sup.routing_sequence_id routing_sequence_id, sup.bill_sequence_id bill_sequence_id, sup.disposition_id disposition_id, sup.refresh_number refresh_number, sup.plan_id, sup.fulfill_orchestration_required, sup.fg_order_type FROM msc_supplies sup WHERE sup.plan_id = -1 AND nvl(sup.quantity_in_process,0) + nvl(sup.implemented_quantity,0) <= nvl(sup.firm_quantity,sup.new_order_quantity) AND sup.order_type IN (1,2,3,7,8,11,12,18,27,31,41,49,53,94)