DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.MSC_CUST_BUCKET_V

Object Details
Object Name: MSC_CUST_BUCKET_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMSC.MSC_CUST_BUCKET_V
Subobject Name:
Status: VALID

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
SALES_FORECAST NUMBER

ORDER_FORECAST NUMBER

SUPPLY_COMMIT NUMBER

HISTORICAL_SALES NUMBER

SELL_THROUGH_FORECAST NUMBER

NEGOTIATED_CAPACITY NUMBER

SAFETY_STOCK NUMBER

ALLOCATED_ONHAND NUMBER

UNALLOCATED_ONHAND NUMBER

PURCHASE_ORDER NUMBER

SALES_ORDER NUMBER

ASN NUMBER

SHIPMENT_RECEIPT NUMBER

REPLENISHMENT NUMBER

REQUISITION NUMBER

PO_ACKNOWLEDGE NUMBER

ITEM_NAME VARCHAR2 (250)
SUPPLIER_NAME VARCHAR2 (255)
SUPPLIER_SITE_NAME VARCHAR2 (40)
CUSTOMER_NAME VARCHAR2 (255)
CUSTOMER_SITE_NAME VARCHAR2 (40)
DOCUMENT_OWNER VARCHAR2 (255)
START_DATE DATE

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SALES_FORECAST
,      ORDER_FORECAST
,      SUPPLY_COMMIT
,      HISTORICAL_SALES
,      SELL_THROUGH_FORECAST
,      NEGOTIATED_CAPACITY
,      SAFETY_STOCK
,      ALLOCATED_ONHAND
,      UNALLOCATED_ONHAND
,      PURCHASE_ORDER
,      SALES_ORDER
,      ASN
,      SHIPMENT_RECEIPT
,      REPLENISHMENT
,      REQUISITION
,      PO_ACKNOWLEDGE
,      ITEM_NAME
,      SUPPLIER_NAME
,      SUPPLIER_SITE_NAME
,      CUSTOMER_NAME
,      CUSTOMER_SITE_NAME
,      DOCUMENT_OWNER
,      START_DATE
FROM APPS.MSC_CUST_BUCKET_V;

Dependencies

[top of page]

APPS.MSC_CUST_BUCKET_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
ViewMSC_SUP_DEM_ENTRIES_UI_V
PL/SQL PackageMSC_X_UTIL - show dependent code

APPS.MSC_CUST_BUCKET_V is not referenced by any database object