VIEW: APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V

Source

View Text - Preformatted

SELECT sd.TRANSACTION_ID, sd.PLAN_ID, sd.SR_INSTANCE_ID, sd.PUBLISHER_ID, sd.PUBLISHER_SITE_ID, sd.INVENTORY_ITEM_ID, sd.SUPPLIER_ID, sd.CUSTOMER_ID, sd.SUPPLIER_SITE_ID, sd.CUSTOMER_SITE_ID, sd.LAST_REFRESH_NUMBER, MSC_X_UDE_PEGGING.DAYS_LATE(sd.TRANSACTION_ID) AS DAYS_LATE, MSC_X_UDE_PEGGING.DAYS_EARLY(sd.TRANSACTION_ID) AS DAYS_EARLY, MSC_X_UDE_PEGGING.QUANTITY_EXCESS(sd.TRANSACTION_ID) AS QUANTITY_EXCESS, MSC_X_UDE_PEGGING.QUANTITY_SHORTAGE(sd.TRANSACTION_ID) AS QUANTITY_SHORTAGE, sd.AVERAGE_ANNUAL_DEMAND, sd.BASE_ITEM_NAME, sd.BILL_OF_LADING_NUMBER, sd.BUCKET_TYPE_DESC, sd.CARRIER_CODE, sd.CATEGORY_NAME, sd.CONTAINER_QTY, sd.CONTAINER_TYPE, sd.CUSTOMER_ITEM_NAME, sd.CUSTOMER_NAME, sd.CUSTOMER_SITE_NAME, sd.DESIGNATOR, sd.END_ORDER_LINE_NUMBER, sd.END_ORDER_NUMBER, sd.END_ORDER_PUBLISHER_NAME, sd.END_ORDER_PUBLISHER_SITE_NAME, sd.END_ORDER_REL_NUMBER, sd.ITEM_DESCRIPTION, sd.ITEM_NAME, sd.LINE_NUMBER, sd.NEED_BY_DATE, sd.NEW_ORDER_PLACEMENT_DATE, sd.NEW_SCHEDULE_DATE, sd.ORDER_NUMBER, sd.OWNER_ITEM_NAME, sd.PLANNER_CODE, sd.PLANNING_GROUP, sd.POSTING_PARTY_NAME, sd.PROJECT_NUMBER, sd.PROMISED_DATE, sd.PUBLISHER_NAME, sd.PUBLISHER_ORDER_TYPE, sd.PUBLISHER_ORDER_TYPE_DESC, sd.PUBLISHER_SITE_NAME, sd.QUANTITY, sd.RECEIPT_DATE, sd.RELEASE_NUMBER, sd.RELEASE_STATUS, sd.REQUEST_DATE, sd.SHIPPING_CONTROL, sd.SHIP_DATE, sd.SHIP_FROM_PARTY_NAME, sd.SHIP_FROM_PARTY_SITE_NAME, sd.SHIP_METHOD, sd.SHIP_TO_PARTY_NAME, sd.SHIP_TO_PARTY_SITE_NAME, sd.SUPPLIER_ITEM_NAME, sd.SUPPLIER_NAME, sd.SUPPLIER_SITE_NAME, sd.TASK_NUMBER, sd.TRACKING_NUMBER, sd.UOM_CODE, sd.VEHICLE_NUMBER, sd.VERSION, sd.WIP_END_DATE, sd.WIP_START_DATE, sd.CREATION_DATE FROM MSC_SUP_DEM_ENTRIES SD WHERE sd.plan_id = -1

View Text - HTML Formatted

SELECT SD.TRANSACTION_ID
, SD.PLAN_ID
, SD.SR_INSTANCE_ID
, SD.PUBLISHER_ID
, SD.PUBLISHER_SITE_ID
, SD.INVENTORY_ITEM_ID
, SD.SUPPLIER_ID
, SD.CUSTOMER_ID
, SD.SUPPLIER_SITE_ID
, SD.CUSTOMER_SITE_ID
, SD.LAST_REFRESH_NUMBER
, MSC_X_UDE_PEGGING.DAYS_LATE(SD.TRANSACTION_ID) AS DAYS_LATE
, MSC_X_UDE_PEGGING.DAYS_EARLY(SD.TRANSACTION_ID) AS DAYS_EARLY
, MSC_X_UDE_PEGGING.QUANTITY_EXCESS(SD.TRANSACTION_ID) AS QUANTITY_EXCESS
, MSC_X_UDE_PEGGING.QUANTITY_SHORTAGE(SD.TRANSACTION_ID) AS QUANTITY_SHORTAGE
, SD.AVERAGE_ANNUAL_DEMAND
, SD.BASE_ITEM_NAME
, SD.BILL_OF_LADING_NUMBER
, SD.BUCKET_TYPE_DESC
, SD.CARRIER_CODE
, SD.CATEGORY_NAME
, SD.CONTAINER_QTY
, SD.CONTAINER_TYPE
, SD.CUSTOMER_ITEM_NAME
, SD.CUSTOMER_NAME
, SD.CUSTOMER_SITE_NAME
, SD.DESIGNATOR
, SD.END_ORDER_LINE_NUMBER
, SD.END_ORDER_NUMBER
, SD.END_ORDER_PUBLISHER_NAME
, SD.END_ORDER_PUBLISHER_SITE_NAME
, SD.END_ORDER_REL_NUMBER
, SD.ITEM_DESCRIPTION
, SD.ITEM_NAME
, SD.LINE_NUMBER
, SD.NEED_BY_DATE
, SD.NEW_ORDER_PLACEMENT_DATE
, SD.NEW_SCHEDULE_DATE
, SD.ORDER_NUMBER
, SD.OWNER_ITEM_NAME
, SD.PLANNER_CODE
, SD.PLANNING_GROUP
, SD.POSTING_PARTY_NAME
, SD.PROJECT_NUMBER
, SD.PROMISED_DATE
, SD.PUBLISHER_NAME
, SD.PUBLISHER_ORDER_TYPE
, SD.PUBLISHER_ORDER_TYPE_DESC
, SD.PUBLISHER_SITE_NAME
, SD.QUANTITY
, SD.RECEIPT_DATE
, SD.RELEASE_NUMBER
, SD.RELEASE_STATUS
, SD.REQUEST_DATE
, SD.SHIPPING_CONTROL
, SD.SHIP_DATE
, SD.SHIP_FROM_PARTY_NAME
, SD.SHIP_FROM_PARTY_SITE_NAME
, SD.SHIP_METHOD
, SD.SHIP_TO_PARTY_NAME
, SD.SHIP_TO_PARTY_SITE_NAME
, SD.SUPPLIER_ITEM_NAME
, SD.SUPPLIER_NAME
, SD.SUPPLIER_SITE_NAME
, SD.TASK_NUMBER
, SD.TRACKING_NUMBER
, SD.UOM_CODE
, SD.VEHICLE_NUMBER
, SD.VERSION
, SD.WIP_END_DATE
, SD.WIP_START_DATE
, SD.CREATION_DATE
FROM MSC_SUP_DEM_ENTRIES SD
WHERE SD.PLAN_ID = -1