VIEW: APPS.MSC_SUP_DEM_ENTRIES_VERT_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, msc_x_util.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE',PUBLISHER_ORDER_TYPE) 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, sup_dem.CREATED_BY, sup_dem.CREATION_DATE, sup_dem.LAST_UPDATED_BY, sup_dem.LAST_UPDATE_DATE, sup_dem.LAST_UPDATE_LOGIN, KEY_DATE, SHIP_DATE, RECEIPT_DATE, ORIGINAL_PROMISED_DATE, REQUEST_DATE, PRIMARY_UOM, PRIMARY_QUANTITY, REF_HEADER_ID, REF_LINE_ID, 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, SUBINVENTORY_CODE, CUSTOMER_ITEM_NAME, SUPPLIER_ITEM_NAME, OWNER_ITEM_NAME, ITEM_NAME, QUANTITY_IN_PROCESS, IMPLEMENTED_QUANTITY, ITEM_DESCRIPTION, CUSTOMER_ITEM_DESCRIPTION, SUPPLIER_ITEM_DESCRIPTION, OWNER_ITEM_DESCRIPTION, TOTAL_QUANTITY, TOTAL_PRIMARY_QUANTITY, TOTAL_TP_QUANTITY, NUMBER1, VMI_FLAG, ACK_FLAG, ACCEPTANCE_REQUIRED_FLAG, DOCUMENT_NUMBER, RESPONSE_NUMBER, NEED_BY_DATE, PROMISED_DATE, base_item_id, base_item_name, shipping_control, LINK_TRANS_ID, INTERNAL_FLAG, msc_x_util.get_buyer_code(inventory_item_id, publisher_id, publisher_site_id, customer_id, customer_site_id, supplier_id, supplier_site_id) BUYER_NAME, msc_x_util.get_category_code(inventory_item_id, publisher_id, publisher_site_id, customer_id, customer_site_id, supplier_id, supplier_site_id) CATEGORY_NAME, shipping_control_code, end_order_type_desc FROM MSC_SUP_DEM_ENTRIES sup_dem

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
, MSC_X_UTIL.GET_LOOKUP_MEANING('MSC_X_ORDER_TYPE'
, PUBLISHER_ORDER_TYPE) 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
, SUP_DEM.CREATED_BY
, SUP_DEM.CREATION_DATE
, SUP_DEM.LAST_UPDATED_BY
, SUP_DEM.LAST_UPDATE_DATE
, SUP_DEM.LAST_UPDATE_LOGIN
, KEY_DATE
, SHIP_DATE
, RECEIPT_DATE
, ORIGINAL_PROMISED_DATE
, REQUEST_DATE
, PRIMARY_UOM
, PRIMARY_QUANTITY
, REF_HEADER_ID
, REF_LINE_ID
, 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
, SUBINVENTORY_CODE
, CUSTOMER_ITEM_NAME
, SUPPLIER_ITEM_NAME
, OWNER_ITEM_NAME
, ITEM_NAME
, QUANTITY_IN_PROCESS
, IMPLEMENTED_QUANTITY
, ITEM_DESCRIPTION
, CUSTOMER_ITEM_DESCRIPTION
, SUPPLIER_ITEM_DESCRIPTION
, OWNER_ITEM_DESCRIPTION
, TOTAL_QUANTITY
, TOTAL_PRIMARY_QUANTITY
, TOTAL_TP_QUANTITY
, NUMBER1
, VMI_FLAG
, ACK_FLAG
, ACCEPTANCE_REQUIRED_FLAG
, DOCUMENT_NUMBER
, RESPONSE_NUMBER
, NEED_BY_DATE
, PROMISED_DATE
, BASE_ITEM_ID
, BASE_ITEM_NAME
, SHIPPING_CONTROL
, LINK_TRANS_ID
, INTERNAL_FLAG
, MSC_X_UTIL.GET_BUYER_CODE(INVENTORY_ITEM_ID
, PUBLISHER_ID
, PUBLISHER_SITE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID) BUYER_NAME
, MSC_X_UTIL.GET_CATEGORY_CODE(INVENTORY_ITEM_ID
, PUBLISHER_ID
, PUBLISHER_SITE_ID
, CUSTOMER_ID
, CUSTOMER_SITE_ID
, SUPPLIER_ID
, SUPPLIER_SITE_ID) CATEGORY_NAME
, SHIPPING_CONTROL_CODE
, END_ORDER_TYPE_DESC
FROM MSC_SUP_DEM_ENTRIES SUP_DEM