Product: | MSC - Advanced Supply Chain Planning |
---|---|
Description: | |
Implementation/DBA Data: | APPS.MSC_SUP_DEM_ENTRIES_V |
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