VIEW: APPS.MSC_SUP_DEM_ENTRIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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