[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_SD_BATCH_INFO_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Contains the batch information
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;
APPS
AR_LOOKUPS
FND_MESSAGE
- show dependent code
HZ_CUST_ACCOUNTS
HZ_CUST_ACCT_SITES_ALL
HZ_CUST_SITE_USES_ALL
HZ_LOCATIONS
HZ_PARTIES
HZ_PARTY_SITES
HZ_RELATIONSHIPS
MTL_SYSTEM_ITEMS_B_KFV
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OZF_RESALE_LINES_ALL
OZF_SD_BATCH_FROM_ROLE_V
OZF_SD_BATCH_HEADERS_ALL
OZF_SD_BATCH_LINES_ALL
OZF_SD_CONTACT_V
RA_CUSTOMER_TRX_ALL
RA_CUSTOMER_TRX_LINES_ALL
APPS
OZF_SD_BATCH_CONTENT_QUERY_V
|
|
|
|