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


VIEW: APPS.MRP_BIS_LATE_ORDERS_V

Object Details
Object Name: MRP_BIS_LATE_ORDERS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_BIS_LATE_ORDERS_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
COMPILE_DESIGNATOR VARCHAR2 (10)
ORGANIZATION_ID NUMBER

ITEM_NUMBER VARCHAR2 (40)
ORDER_QUANTITY NUMBER

UOM_CODE VARCHAR2 (3)
DUE_DATE DATE

EXPECTED_SHIP_DATE DATE

ORDER_ID NUMBER

ORDER_NUMBER VARCHAR2 (4000)
ORDER_LINE_ID NUMBER

ORDER_LINE_NUMBER NUMBER

CUSTOMER_ID NUMBER

CUSTOMER_NAME VARCHAR2 (50)
SHIP_TO_ID NUMBER

SHIP_TO_ADDRESS VARCHAR2 (240)
Query Text

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


SELECT COMPILE_DESIGNATOR
,      ORGANIZATION_ID
,      ITEM_NUMBER
,      ORDER_QUANTITY
,      UOM_CODE
,      DUE_DATE
,      EXPECTED_SHIP_DATE
,      ORDER_ID
,      ORDER_NUMBER
,      ORDER_LINE_ID
,      ORDER_LINE_NUMBER
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SHIP_TO_ID
,      SHIP_TO_ADDRESS
FROM APPS.MRP_BIS_LATE_ORDERS_V;

Dependencies

[top of page]

APPS.MRP_BIS_LATE_ORDERS_V references the following:

SchemaAPPS
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
PL/SQL PackageINV_SALESORDER - show dependent code
SynonymMRP_EXCEPTION_DETAILS
SynonymMRP_FULL_PEGGING
PL/SQL PackageMRP_GET_BIS_VALUES - show dependent code
PL/SQL PackageMRP_GET_ORDER - show dependent code
SynonymMRP_GROSS_REQUIREMENTS
SynonymMRP_SCHEDULE_DATES
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymOE_ORDER_LINES_ALL

APPS.MRP_BIS_LATE_ORDERS_V is not referenced by any database object