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

VIEW: APPS.MRP_CUST_SUP_ORG_V

Object Details
Object Name: MRP_CUST_SUP_ORG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewMRP.MRP_CUST_SUP_ORG_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
ORGANIZATION_ID NUMBER (15) Yes Organization identifier
ORGANIZATION_CODE VARCHAR2 (3)
Organization code
CUSTOMER_ID VARCHAR2 (150)
Customer identifier
CUSTOMER_NAME VARCHAR2 (360)
Customer name
SHIP_TO_SITE_ID VARCHAR2 (150)
Ship to site identifier
SHIP_TO_ADDRESS VARCHAR2 (240)
Ship to address
SUPPLIER_ID VARCHAR2 (150)
Supplier identifier
SUPPLIER_NAME VARCHAR2 (240)
Supplier name
SUPPLIER_SITE_ID VARCHAR2 (150)
Supplier site identifier
SUPPLIER_SITE VARCHAR2 (15)
Supplier site
Query Text

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


SELECT ORGANIZATION_ID
,      ORGANIZATION_CODE
,      CUSTOMER_ID
,      CUSTOMER_NAME
,      SHIP_TO_SITE_ID
,      SHIP_TO_ADDRESS
,      SUPPLIER_ID
,      SUPPLIER_NAME
,      SUPPLIER_SITE_ID
,      SUPPLIER_SITE
FROM APPS.MRP_CUST_SUP_ORG_V;

Dependencies

[top of page]

APPS.MRP_CUST_SUP_ORG_V references the following:

SchemaAPPS
PL/SQL PackageFND_GLOBAL - show dependent code
PL/SQL PackageHR_API - show dependent code
ViewHR_ORGANIZATION_INFORMATION_V
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymMTL_PARAMETERS
ViewPO_VENDORS
ViewPO_VENDOR_SITES_ALL
APPS.MRP_CUST_SUP_ORG_V is referenced by following:

SchemaAPPS
Package BodyMRP_ASSIGNMENT_PVT - show dependent code
Package BodyMRP_SELECT_ALL_FOR_RELEASE_PUB - show dependent code
Package BodyMRP_SOURCING_RULE_PVT - show dependent code
ViewMRP_SR_RECEIPT_ORG_V