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


VIEW: APPS.OZF_SD_BATCH_INFO_V

Object Details
Object Name: OZF_SD_BATCH_INFO_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Contains the batch information


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER

SHIP_FRM_SD_AUTHORIZATION_ID VARCHAR2 (30)
DIST_BY_BUSINESS_NAME VARCHAR2 (240)
DIST_BY_GBL_BUSINESS_ID CHAR (9)
DIST_BY_GBL_SUPPLY_CHAIN_CODE VARCHAR2 (30)
DIST_BY_PROP_BUSINESS_ID VARCHAR2 (0)
DIST_BY_PROP_DOMAIN_ID1 VARCHAR2 (0)
DIST_BY_PROP_AUTH_ID1 VARCHAR2 (0)
DIST_BY_GBL_PARTNER_CLASS_CODE VARCHAR2 (4000)
DIST_BY_CONTACT1_NAME VARCHAR2 (360)
DIST_BY_CONTACT1_EMAIL VARCHAR2 (2000)
DIST_BY_CONTACT1_PHONE VARCHAR2 (2000)
DIST_BY_CONTACT1_FAX VARCHAR2 (0)
DIST_BY_GBL_LOCATION_ID VARCHAR2 (60)
DIST_BY_PROP_DOMAIN_ID2 VARCHAR2 (0)
DIST_BY_PROP_IDAUTHORITY2 VARCHAR2 (0)
DIST_BY_PROP_LOCATION_ID VARCHAR2 (0)
DIST_BY_ADDRESS_LINE1 VARCHAR2 (240)
DIST_BY_ADDRESS_LINE2 VARCHAR2 (240)
DIST_BY_ADDRESS_LINE3 VARCHAR2 (240)
DIST_BY_CITY_NAME VARCHAR2 (30)
DIST_BY_GBL_COUNTRY_CODE VARCHAR2 (60)
DIST_BY_NATIONAL_POSTAL_CODE VARCHAR2 (30)
DIST_BY_POBOX_ID VARCHAR2 (30)
DIST_BY_REGION_NAME VARCHAR2 (120)
SHIP_TO_BUSINESS_NAME VARCHAR2 (360)
SHIP_TO_GBL_BUSINESS_ID NUMBER

SHIP_TO_GBL_SUPPLY_CHAIN_CODE VARCHAR2 (30)
SHIP_TO_PROP_BUSINESS_ID VARCHAR2 (30)
SHIP_TO_PROP_DOMAIN_ID1 VARCHAR2 (0)
SHIP_TO_PROP_ID_AUTHORITY1 VARCHAR2 (0)
SHIP_TO_PROP_DOMAIN_ID2 VARCHAR2 (0)
SHIP_TO_PROP_ID_AUTHORITY2 VARCHAR2 (0)
SHIP_TO_PROP_LOC_ID NUMBER (15)
SHIP_TO_GBL_LOC_ID VARCHAR2 (240)
SHIP_TO_GBL_PARTNER_CLASS_CODE VARCHAR2 (4000)
SHIP_TO_ADDRESS_LINE1 VARCHAR2 (240)
SHIP_TO_ADDRESS_LINE2 VARCHAR2 (240)
SHIP_TO_ADDRESS_LINE3 VARCHAR2 (481)
SHIP_TO_CITY_NAME VARCHAR2 (60)
SHIP_TO_REGION_NAME VARCHAR2 (60)
SHIP_TO_NATIONAL_POSTAL_CODE VARCHAR2 (60)
SHIP_TO_GBL_COUNTRY_CODE VARCHAR2 (60)
SHIP_TO_POBOX_ID VARCHAR2 (50)
SHIP_TO_CONTACT1_NAME VARCHAR2 (383)
SHIP_TO_CONTACT1_EMAIL VARCHAR2 (2000)
SHIP_TO_CONTACT1_PHONE VARCHAR2 (60)
SHIP_TO_CONTACT1_FAX VARCHAR2 (0)
SOLD_TO_BUSINESS_NAME VARCHAR2 (360)
SOLD_TO_GBL_BUSINESS_ID NUMBER

SOLD_TO_GBL_SUPPLY_CHAIN_CODE VARCHAR2 (30)
SOLD_TO_PROP_BUSINESS_ID VARCHAR2 (30)
SOLD_TO_PROP_DOMAIN_ID1 VARCHAR2 (0)
SOLD_TO_PROP_ID_AUTHORITY1 VARCHAR2 (0)
SOLD_TO_PROP_DOMAIN_ID2 VARCHAR2 (0)
SOLD_TO_PROP_ID_AUTHORITY2 VARCHAR2 (0)
SOLD_TO_PROP_LOC_ID NUMBER (15)
SOLD_TO_GBL_LOC_ID VARCHAR2 (240)
SOLD_TO_GBL_PARTNER_CLASS_CODE VARCHAR2 (4000)
SOLD_TO_ADDRESS_LINE1 VARCHAR2 (240)
SOLD_TO_ADDRESS_LINE2 VARCHAR2 (240)
SOLD_TO_ADDRESS_LINE3 VARCHAR2 (481)
SOLD_TO_CITY_NAME VARCHAR2 (60)
SOLD_TO_REGION_NAME VARCHAR2 (60)
SOLD_TO_NATIONAL_POSTAL_CODE VARCHAR2 (60)
SOLD_TO_GBL_COUNTRY_CODE VARCHAR2 (60)
SOLD_TO_POBOX_ID VARCHAR2 (50)
SOLD_TO_CONTACT1_NAME VARCHAR2 (383)
SOLD_TO_CONTACT1_EMAIL VARCHAR2 (2000)
SOLD_TO_CONTACT1_PHONE VARCHAR2 (60)
SOLD_TO_CONTACT1_FAX VARCHAR2 (0)
USED_BY_BUSINESS_NAME VARCHAR2 (360)
USED_BY_GBL_BUSINESS_ID NUMBER

USED_BY_GBL_SUPPLY_CHAIN_CODE VARCHAR2 (30)
USED_BY_PROP_BUSINESS_ID VARCHAR2 (30)
USED_BY_PROP_DOMAIN_ID1 VARCHAR2 (0)
USED_BY_PROP_ID_AUTHORITY1 VARCHAR2 (0)
USED_BY_PROP_DOMAIN_ID2 VARCHAR2 (0)
USED_BY_PROP_ID_AUTHORITY2 VARCHAR2 (0)
USED_BY_PROP_LOC_ID NUMBER (15)
USED_BY_GBL_LOC_ID VARCHAR2 (240)
USED_BY_GBL_PARTNER_CLASS_CODE VARCHAR2 (4000)
USED_BY_ADDRESS_LINE1 VARCHAR2 (240)
USED_BY_ADDRESS_LINE2 VARCHAR2 (240)
USED_BY_ADDRESS_LINE3 VARCHAR2 (481)
USED_BY_CITY_NAME VARCHAR2 (60)
USED_BY_REGION_NAME VARCHAR2 (60)
USED_BY_NATIONAL_POSTAL_CODE VARCHAR2 (60)
USED_BY_GBL_COUNTRY_CODE VARCHAR2 (60)
USED_BY_POBOX_ID VARCHAR2 (0)
USED_BY_CONTACT1_NAME VARCHAR2 (383)
USED_BY_CONTACT1_EMAIL VARCHAR2 (2000)
USED_BY_CONTACT1_PHONE VARCHAR2 (60)
USED_BY_CONTACT1_FAX VARCHAR2 (0)
SHIP_FRM_SD_CLAIM_REQUEST_DATE DATE

SHIP_FRM_SD_CLAIM_REQUEST_ID VARCHAR2 (30)
CREDIT_REFERENCE_ID VARCHAR2 (0)
DEBIT_REFERENCE_ID VARCHAR2 (30)
GBL_DOC_REF_TYPE_CODE_BATCH VARCHAR2 (4000)
BATCH_LINE_NUMBER NUMBER

GBL_DOC_REF_TYPE_CODE_ORDER VARCHAR2 (4000)
ORDER_DATE DATE

ORDER_LINE_NUMBER VARCHAR2 (40)
ORDER_NUMBER VARCHAR2 (50)
GBL_DOC_REF_TYPE_CODE_INVOICE VARCHAR2 (4000)
INVOICE_DATE DATE

INVOICE_LINE_NUMBER VARCHAR2 (40)
INVOICE_NUMBER VARCHAR2 (50)
DISCOUNT_TYPE VARCHAR2 (30)
DISCOUNT_VALUE NUMBER

DISCOUNT_CURRENCY VARCHAR2 (15)
GBL_PRICE_TYPE_CODE_LIST VARCHAR2 (4000)
COST_CURRENCYCODE VARCHAR2 (15)
COST_MONETARY_AMOUNT NUMBER

GBL_PRICE_TYPE_CODE_AGREEMENT VARCHAR2 (4000)
AUTH_COST_CURRENCY_CODE VARCHAR2 (15)
AUTH_COST_MONETARY_AMOUNT NUMBER

AUTH_COST_MONETARY_AMOUNT_XML NUMBER

INV_CHRG_TYPE_CODE VARCHAR2 (21)
GBL_PRICE_TYPE_CODE_RESALE VARCHAR2 (4000)
RESALE_CURRENCY_CODE VARCHAR2 (15)
RESALE_MONETARY_AMOUNT NUMBER

GBL_UOM VARCHAR2 (3)
GBL_CLAIM_DISPOSITION_CODE VARCHAR2 (30)
DISPUTE_CODE1 VARCHAR2 (0)
DISPUTE_CODE2 VARCHAR2 (0)
DISPUTE_CODE3 VARCHAR2 (0)
DISPUTE_CODE4 VARCHAR2 (0)
DISPUTE_CODE5 VARCHAR2 (0)
DISPUTE_CODE6 VARCHAR2 (0)
DISPUTE_CODE7 VARCHAR2 (0)
DISPUTE_CODE8 VARCHAR2 (0)
DISPUTE_CODE9 VARCHAR2 (0)
DISPUTE_CODE10 VARCHAR2 (0)
GBL_PTNR_CLASS_CODE_DIST VARCHAR2 (4000)
DIST_PRODUCT_ID VARCHAR2 (40)
GBL_PTNR_CLASS_CODE_MANU VARCHAR2 (4000)
VENDOR_PRODUCT_ID VARCHAR2 (240)
SHIP_DATE DATE

SHIPPED_QUANTITY NUMBER

CLAIM_AMOUNT_CURRENCY_CODE VARCHAR2 (15)
LAST_SUB_CLAIM_AMOUNT NUMBER

VENDOR_AUTH_LINEITEM_LINE_NBR VARCHAR2 (0)
VENDOR_AUTH_COST_CURRENCY_CODE VARCHAR2 (15)
VENDOR_AUTH_COST_MONETARY_AMT VARCHAR2 (0)
VENDOR_AUTH_QTY VARCHAR2 (0)
BATCH_SUBMISSION_DATE DATE

BATCH_LINE_ID NUMBER

THIS_DOC_ID NUMBER

HDR_ATTR_CATG VARCHAR2 (30)
HDR_ATTR1 VARCHAR2 (150)
HDR_ATTR2 VARCHAR2 (150)
HDR_ATTR3 VARCHAR2 (150)
HDR_ATTR4 VARCHAR2 (150)
HDR_ATTR5 VARCHAR2 (150)
HDR_ATTR6 VARCHAR2 (150)
HDR_ATTR7 VARCHAR2 (150)
HDR_ATTR8 VARCHAR2 (150)
HDR_ATTR9 VARCHAR2 (150)
HDR_ATTR10 VARCHAR2 (150)
HDR_ATTR11 VARCHAR2 (150)
HDR_ATTR12 VARCHAR2 (150)
HDR_ATTR13 VARCHAR2 (150)
HDR_ATTR14 VARCHAR2 (150)
HDR_ATTR15 VARCHAR2 (150)
HDR_ATTR16 VARCHAR2 (150)
HDR_ATTR17 VARCHAR2 (150)
HDR_ATTR18 VARCHAR2 (150)
HDR_ATTR19 VARCHAR2 (150)
HDR_ATTR20 VARCHAR2 (150)
HDR_ATTR21 VARCHAR2 (150)
HDR_ATTR22 VARCHAR2 (150)
HDR_ATTR23 VARCHAR2 (150)
HDR_ATTR24 VARCHAR2 (150)
HDR_ATTR25 VARCHAR2 (150)
HDR_ATTR26 VARCHAR2 (150)
HDR_ATTR27 VARCHAR2 (150)
HDR_ATTR28 VARCHAR2 (150)
HDR_ATTR29 VARCHAR2 (150)
HDR_ATTR30 VARCHAR2 (150)
LINE_ATTR_CATG VARCHAR2 (30)
LINE_ATTR1 VARCHAR2 (150)
LINE_ATTR2 VARCHAR2 (150)
LINE_ATTR3 VARCHAR2 (150)
LINE_ATTR4 VARCHAR2 (150)
LINE_ATTR5 VARCHAR2 (150)
LINE_ATTR6 VARCHAR2 (150)
LINE_ATTR7 VARCHAR2 (150)
LINE_ATTR8 VARCHAR2 (150)
LINE_ATTR9 VARCHAR2 (150)
LINE_ATTR10 VARCHAR2 (150)
LINE_ATTR11 VARCHAR2 (150)
LINE_ATTR12 VARCHAR2 (150)
LINE_ATTR13 VARCHAR2 (150)
LINE_ATTR14 VARCHAR2 (150)
LINE_ATTR15 VARCHAR2 (150)
LINE_ATTR16 VARCHAR2 (150)
LINE_ATTR17 VARCHAR2 (150)
LINE_ATTR18 VARCHAR2 (150)
LINE_ATTR19 VARCHAR2 (150)
LINE_ATTR20 VARCHAR2 (150)
LINE_ATTR21 VARCHAR2 (150)
LINE_ATTR22 VARCHAR2 (150)
LINE_ATTR23 VARCHAR2 (150)
LINE_ATTR24 VARCHAR2 (150)
LINE_ATTR25 VARCHAR2 (150)
LINE_ATTR26 VARCHAR2 (150)
LINE_ATTR27 VARCHAR2 (150)
LINE_ATTR28 VARCHAR2 (150)
LINE_ATTR29 VARCHAR2 (150)
LINE_ATTR30 VARCHAR2 (150)
Query Text

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


SELECT BATCH_ID
,      SHIP_FRM_SD_AUTHORIZATION_ID
,      DIST_BY_BUSINESS_NAME
,      DIST_BY_GBL_BUSINESS_ID
,      DIST_BY_GBL_SUPPLY_CHAIN_CODE
,      DIST_BY_PROP_BUSINESS_ID
,      DIST_BY_PROP_DOMAIN_ID1
,      DIST_BY_PROP_AUTH_ID1
,      DIST_BY_GBL_PARTNER_CLASS_CODE
,      DIST_BY_CONTACT1_NAME
,      DIST_BY_CONTACT1_EMAIL
,      DIST_BY_CONTACT1_PHONE
,      DIST_BY_CONTACT1_FAX
,      DIST_BY_GBL_LOCATION_ID
,      DIST_BY_PROP_DOMAIN_ID2
,      DIST_BY_PROP_IDAUTHORITY2
,      DIST_BY_PROP_LOCATION_ID
,      DIST_BY_ADDRESS_LINE1
,      DIST_BY_ADDRESS_LINE2
,      DIST_BY_ADDRESS_LINE3
,      DIST_BY_CITY_NAME
,      DIST_BY_GBL_COUNTRY_CODE
,      DIST_BY_NATIONAL_POSTAL_CODE
,      DIST_BY_POBOX_ID
,      DIST_BY_REGION_NAME
,      SHIP_TO_BUSINESS_NAME
,      SHIP_TO_GBL_BUSINESS_ID
,      SHIP_TO_GBL_SUPPLY_CHAIN_CODE
,      SHIP_TO_PROP_BUSINESS_ID
,      SHIP_TO_PROP_DOMAIN_ID1
,      SHIP_TO_PROP_ID_AUTHORITY1
,      SHIP_TO_PROP_DOMAIN_ID2
,      SHIP_TO_PROP_ID_AUTHORITY2
,      SHIP_TO_PROP_LOC_ID
,      SHIP_TO_GBL_LOC_ID
,      SHIP_TO_GBL_PARTNER_CLASS_CODE
,      SHIP_TO_ADDRESS_LINE1
,      SHIP_TO_ADDRESS_LINE2
,      SHIP_TO_ADDRESS_LINE3
,      SHIP_TO_CITY_NAME
,      SHIP_TO_REGION_NAME
,      SHIP_TO_NATIONAL_POSTAL_CODE
,      SHIP_TO_GBL_COUNTRY_CODE
,      SHIP_TO_POBOX_ID
,      SHIP_TO_CONTACT1_NAME
,      SHIP_TO_CONTACT1_EMAIL
,      SHIP_TO_CONTACT1_PHONE
,      SHIP_TO_CONTACT1_FAX
,      SOLD_TO_BUSINESS_NAME
,      SOLD_TO_GBL_BUSINESS_ID
,      SOLD_TO_GBL_SUPPLY_CHAIN_CODE
,      SOLD_TO_PROP_BUSINESS_ID
,      SOLD_TO_PROP_DOMAIN_ID1
,      SOLD_TO_PROP_ID_AUTHORITY1
,      SOLD_TO_PROP_DOMAIN_ID2
,      SOLD_TO_PROP_ID_AUTHORITY2
,      SOLD_TO_PROP_LOC_ID
,      SOLD_TO_GBL_LOC_ID
,      SOLD_TO_GBL_PARTNER_CLASS_CODE
,      SOLD_TO_ADDRESS_LINE1
,      SOLD_TO_ADDRESS_LINE2
,      SOLD_TO_ADDRESS_LINE3
,      SOLD_TO_CITY_NAME
,      SOLD_TO_REGION_NAME
,      SOLD_TO_NATIONAL_POSTAL_CODE
,      SOLD_TO_GBL_COUNTRY_CODE
,      SOLD_TO_POBOX_ID
,      SOLD_TO_CONTACT1_NAME
,      SOLD_TO_CONTACT1_EMAIL
,      SOLD_TO_CONTACT1_PHONE
,      SOLD_TO_CONTACT1_FAX
,      USED_BY_BUSINESS_NAME
,      USED_BY_GBL_BUSINESS_ID
,      USED_BY_GBL_SUPPLY_CHAIN_CODE
,      USED_BY_PROP_BUSINESS_ID
,      USED_BY_PROP_DOMAIN_ID1
,      USED_BY_PROP_ID_AUTHORITY1
,      USED_BY_PROP_DOMAIN_ID2
,      USED_BY_PROP_ID_AUTHORITY2
,      USED_BY_PROP_LOC_ID
,      USED_BY_GBL_LOC_ID
,      USED_BY_GBL_PARTNER_CLASS_CODE
,      USED_BY_ADDRESS_LINE1
,      USED_BY_ADDRESS_LINE2
,      USED_BY_ADDRESS_LINE3
,      USED_BY_CITY_NAME
,      USED_BY_REGION_NAME
,      USED_BY_NATIONAL_POSTAL_CODE
,      USED_BY_GBL_COUNTRY_CODE
,      USED_BY_POBOX_ID
,      USED_BY_CONTACT1_NAME
,      USED_BY_CONTACT1_EMAIL
,      USED_BY_CONTACT1_PHONE
,      USED_BY_CONTACT1_FAX
,      SHIP_FRM_SD_CLAIM_REQUEST_DATE
,      SHIP_FRM_SD_CLAIM_REQUEST_ID
,      CREDIT_REFERENCE_ID
,      DEBIT_REFERENCE_ID
,      GBL_DOC_REF_TYPE_CODE_BATCH
,      BATCH_LINE_NUMBER
,      GBL_DOC_REF_TYPE_CODE_ORDER
,      ORDER_DATE
,      ORDER_LINE_NUMBER
,      ORDER_NUMBER
,      GBL_DOC_REF_TYPE_CODE_INVOICE
,      INVOICE_DATE
,      INVOICE_LINE_NUMBER
,      INVOICE_NUMBER
,      DISCOUNT_TYPE
,      DISCOUNT_VALUE
,      DISCOUNT_CURRENCY
,      GBL_PRICE_TYPE_CODE_LIST
,      COST_CURRENCYCODE
,      COST_MONETARY_AMOUNT
,      GBL_PRICE_TYPE_CODE_AGREEMENT
,      AUTH_COST_CURRENCY_CODE
,      AUTH_COST_MONETARY_AMOUNT
,      AUTH_COST_MONETARY_AMOUNT_XML
,      INV_CHRG_TYPE_CODE
,      GBL_PRICE_TYPE_CODE_RESALE
,      RESALE_CURRENCY_CODE
,      RESALE_MONETARY_AMOUNT
,      GBL_UOM
,      GBL_CLAIM_DISPOSITION_CODE
,      DISPUTE_CODE1
,      DISPUTE_CODE2
,      DISPUTE_CODE3
,      DISPUTE_CODE4
,      DISPUTE_CODE5
,      DISPUTE_CODE6
,      DISPUTE_CODE7
,      DISPUTE_CODE8
,      DISPUTE_CODE9
,      DISPUTE_CODE10
,      GBL_PTNR_CLASS_CODE_DIST
,      DIST_PRODUCT_ID
,      GBL_PTNR_CLASS_CODE_MANU
,      VENDOR_PRODUCT_ID
,      SHIP_DATE
,      SHIPPED_QUANTITY
,      CLAIM_AMOUNT_CURRENCY_CODE
,      LAST_SUB_CLAIM_AMOUNT
,      VENDOR_AUTH_LINEITEM_LINE_NBR
,      VENDOR_AUTH_COST_CURRENCY_CODE
,      VENDOR_AUTH_COST_MONETARY_AMT
,      VENDOR_AUTH_QTY
,      BATCH_SUBMISSION_DATE
,      BATCH_LINE_ID
,      THIS_DOC_ID
,      HDR_ATTR_CATG
,      HDR_ATTR1
,      HDR_ATTR2
,      HDR_ATTR3
,      HDR_ATTR4
,      HDR_ATTR5
,      HDR_ATTR6
,      HDR_ATTR7
,      HDR_ATTR8
,      HDR_ATTR9
,      HDR_ATTR10
,      HDR_ATTR11
,      HDR_ATTR12
,      HDR_ATTR13
,      HDR_ATTR14
,      HDR_ATTR15
,      HDR_ATTR16
,      HDR_ATTR17
,      HDR_ATTR18
,      HDR_ATTR19
,      HDR_ATTR20
,      HDR_ATTR21
,      HDR_ATTR22
,      HDR_ATTR23
,      HDR_ATTR24
,      HDR_ATTR25
,      HDR_ATTR26
,      HDR_ATTR27
,      HDR_ATTR28
,      HDR_ATTR29
,      HDR_ATTR30
,      LINE_ATTR_CATG
,      LINE_ATTR1
,      LINE_ATTR2
,      LINE_ATTR3
,      LINE_ATTR4
,      LINE_ATTR5
,      LINE_ATTR6
,      LINE_ATTR7
,      LINE_ATTR8
,      LINE_ATTR9
,      LINE_ATTR10
,      LINE_ATTR11
,      LINE_ATTR12
,      LINE_ATTR13
,      LINE_ATTR14
,      LINE_ATTR15
,      LINE_ATTR16
,      LINE_ATTR17
,      LINE_ATTR18
,      LINE_ATTR19
,      LINE_ATTR20
,      LINE_ATTR21
,      LINE_ATTR22
,      LINE_ATTR23
,      LINE_ATTR24
,      LINE_ATTR25
,      LINE_ATTR26
,      LINE_ATTR27
,      LINE_ATTR28
,      LINE_ATTR29
,      LINE_ATTR30
FROM APPS.OZF_SD_BATCH_INFO_V;

Dependencies

[top of page]

APPS.OZF_SD_BATCH_INFO_V references the following:

SchemaAPPS
ViewAR_LOOKUPS
PL/SQL PackageFND_MESSAGE - show dependent code
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_CUST_ACCT_SITES_ALL
SynonymHZ_CUST_SITE_USES_ALL
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
SynonymHZ_RELATIONSHIPS
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOZF_RESALE_LINES_ALL
ViewOZF_SD_BATCH_FROM_ROLE_V
SynonymOZF_SD_BATCH_HEADERS_ALL
SynonymOZF_SD_BATCH_LINES_ALL
ViewOZF_SD_CONTACT_V
SynonymRA_CUSTOMER_TRX_ALL
SynonymRA_CUSTOMER_TRX_LINES_ALL
APPS.OZF_SD_BATCH_INFO_V is referenced by following:

SchemaAPPS
ViewOZF_SD_BATCH_CONTENT_QUERY_V