View: MSC_SUP_DEM_ENT_CUSTOM_EX_V

Product:	MSC - Advanced Supply Chain Planning
Description:
Implementation/DBA Data:	APPS.MSC_SUP_DEM_ENT_CUSTOM_EX_V

View Text

SELECT SD.TRANSACTION_ID
, SD.PLAN_ID
, SD.SR_INSTANCE_ID
, SD.PUBLISHER_ID
, SD.PUBLISHER_SITE_ID
, SD.PUBLISHER_NAME
, SD.PUBLISHER_SITE_NAME
, SD.NEW_SCHEDULE_DATE
, SD.INVENTORY_ITEM_ID
, SD.QUANTITY
, SD.TP_QUANTITY
, SD.COMMENTS
, SD.PUBLISHER_ORDER_TYPE
, SD.SUPPLIER_ID
, SD.SUPPLIER_NAME
, SD.SUPPLIER_SITE_ID
, SD.SUPPLIER_SITE_NAME
, SD.CUSTOMER_ID
, SD.CUSTOMER_NAME
, SD.CUSTOMER_SITE_ID
, SD.CUSTOMER_SITE_NAME
, MSC_X_UDE_PEGGING.DAYS_LATE(SD.TRANSACTION_ID)
, MSC_X_UDE_PEGGING.DAYS_EARLY(SD.TRANSACTION_ID)
, MSC_X_UDE_PEGGING.QUANTITY_EXCESS(SD.TRANSACTION_ID)
, MSC_X_UDE_PEGGING.QUANTITY_SHORTAGE(SD.TRANSACTION_ID)
, SD.LINE_CODE
, SD.BUCKET_TYPE
, SD.ORDER_NUMBER
, SD.END_ORDER_NUMBER
, SD.NEW_DOCK_DATE
, SD.POSTING_PARTY_ID
, SD.NEW_SHIP_DATE
, SD.NEW_ORDER_PLACEMENT_DATE
, SD.RELEASE_NUMBER
, SD.LINE_NUMBER
, SD.END_ORDER_REL_NUMBER
, SD.END_ORDER_LINE_NUMBER
, SD.PUBLISHER_ADDRESS_ID
, SD.CARRIER_CODE
, SD.VEHICLE_NUMBER
, SD.CONTAINER_TYPE
, SD.CONTAINER_QTY
, SD.TRACKING_NUMBER
, SD.VERSION
, SD.END_ORDER_TYPE
, SD.END_ORDER_PUBLISHER_ID
, SD.SHIP_TO_ADDRESS
, SD.SHIP_FROM_PARTY_ID
, SD.SHIP_TO_PARTY_ID
, SD.SHIP_TO_PARTY_SITE_ID
, SD.SHIP_TO_PARTY_ADDRESS_ID
, SD.SHIP_TO_PARTY_NAME
, SD.SHIP_TO_PARTY_SITE_NAME
, SD.SHIP_FROM_PARTY_ADDRESS_ID
, SD.SHIP_FROM_PARTY_SITE_ID
, SD.SHIP_FROM_PARTY_NAME
, SD.SHIP_FROM_PARTY_SITE_NAME
, SD.OWNING_SITE_ID
, SD.OWNING_SITE_NAME
, SD.END_ORDER_PUBLISHER_SITE_ID
, SD.END_ORDER_PUBLISHER_SITE_NAME
, SD.END_ORDER_PUBLISHER_NAME
, SD.PUBLISHER_ORDER_TYPE_DESC
, SD.TP_ORDER_TYPE_DESC
, SD.DESIGNATOR
, SD.CONTEXT
, SD.UNIT_NUMBER
, SD.SHIP_METHOD
, SD.PROJECT_NUMBER
, SD.TASK_NUMBER
, SD.PLANNING_GROUP
, SD.SHIP_FROM_ADDRESS
, SD.PUBLISHER_ADDRESS
, SD.CUSTOMER_ADDRESS
, SD.SUPPLIER_ADDRESS
, SD.AVERAGE_ANNUAL_DEMAND
, SD.BILL_OF_LADING_NUMBER
, SD.BUCKET_TYPE_DESC
, SD.SERIAL_NUMBER
, SD.RELEASE_STATUS
, SD.INVENTORY_STATUS
, SD.WIP_END_DATE
, SD.WIP_START_DATE
, SD.PROMISE_SHIP_DATE
, SD.NEW_SCHEDULE_END_DATE
, SD.POSTING_PARTY_NAME
, SD.UOM_CODE
, SD.TP_UOM_CODE
, SD.PLANNER_CODE
, SD.LAST_REFRESH_NUMBER
, SD.ATTACHMENT_URL
, SD.ATTRIBUTE1
, SD.ATTRIBUTE2
, SD.ATTRIBUTE3
, SD.ATTRIBUTE4
, SD.ATTRIBUTE5
, SD.ATTRIBUTE6
, SD.ATTRIBUTE7
, SD.ATTRIBUTE8
, SD.ATTRIBUTE9
, SD.ATTRIBUTE10
, SD.ATTRIBUTE11
, SD.ATTRIBUTE12
, SD.ATTRIBUTE13
, SD.ATTRIBUTE14
, SD.ATTRIBUTE15
, SD.REQUEST_ID
, SD.PROGRAM_ID
, SD.PROGRAM_APPLICATION_ID
, SD.PROGRAM_UPDATE_DATE
, SD.CREATED_BY
, SD.CREATION_DATE
, SD.LAST_UPDATED_BY
, SD.LAST_UPDATE_DATE
, SD.LAST_UPDATE_LOGIN
, SD.KEY_DATE
, SD.SHIP_DATE
, SD.RECEIPT_DATE
, SD.ORIGINAL_PROMISED_DATE
, SD.REQUEST_DATE
, SD.PRIMARY_UOM
, SD.PRIMARY_QUANTITY
, SD.REF_HEADER_ID
, SD.REF_LINE_ID
, SD.CATEGORY_NAME
, SD.PUBLISHER_ORG_ID
, SD.SUBSCRIBER_ORG_ID
, SD.ASSEMBLY_ITEM_ID
, SD.CATEGORY_ID
, SD.START_DATE
, SD.END_DATE
, SD.PRODUCTION_SEQUENCE
, SD.SEQ_PLAN_COMPLETION_FLAG
, SD.INPUT_PLAN_ID
, SD.END_ASSEMBLY_ITEM_NAME
, SD.SUBSCRIBER_ADDRESS_ID
, SD.TP_ORDER_TYPE
, SD.PROCESSED_FLAG
, SD.PLANNED_WIP_START_DATE
, SD.PLANNED_WIP_END_DATE
, SD.QUANTITY_IN_PROCESS
, SD.IMPLEMENTED_QUANTITY
, SD.ITEM_NAME
, SD.OWNER_ITEM_NAME
, SD.CUSTOMER_ITEM_NAME
, SD.SUPPLIER_ITEM_NAME
, SD.ITEM_DESCRIPTION
, SD.CUSTOMER_ITEM_DESCRIPTION
, SD.SUPPLIER_ITEM_DESCRIPTION
, SD.OWNER_ITEM_DESCRIPTION
FROM MSC_SUP_DEM_ENTRIES_V SD
WHERE SD.PLAN_ID = -1

Columns