DBA Data[Home] [Help]

VIEW: APPS.MRP_BIS_FORECAST_WB_V

Source

View Text - Preformatted

SELECT organization_code, organization_name, forecast_set, NULL, demand_class, NULL, category_set, category, category_description, NULL, product_family_number, product_family_desc, item_number, item_description, NULL, customer_class, customer, ship_to_address, ship_to_city, ship_to_state, ship_to_zip, bill_to_address, bill_to_city, bill_to_state, bill_to_zip, forecast_date, forecast_quantity, order_quantity, shipped_quantity, forecast_amount, order_amount, shipped_amount FROM mrp_bis_forecast_wb
View Text - HTML Formatted

SELECT ORGANIZATION_CODE
, ORGANIZATION_NAME
, FORECAST_SET
, NULL
, DEMAND_CLASS
, NULL
, CATEGORY_SET
, CATEGORY
, CATEGORY_DESCRIPTION
, NULL
, PRODUCT_FAMILY_NUMBER
, PRODUCT_FAMILY_DESC
, ITEM_NUMBER
, ITEM_DESCRIPTION
, NULL
, CUSTOMER_CLASS
, CUSTOMER
, SHIP_TO_ADDRESS
, SHIP_TO_CITY
, SHIP_TO_STATE
, SHIP_TO_ZIP
, BILL_TO_ADDRESS
, BILL_TO_CITY
, BILL_TO_STATE
, BILL_TO_ZIP
, FORECAST_DATE
, FORECAST_QUANTITY
, ORDER_QUANTITY
, SHIPPED_QUANTITY
, FORECAST_AMOUNT
, ORDER_AMOUNT
, SHIPPED_AMOUNT
FROM MRP_BIS_FORECAST_WB