[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
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_ID | NUMBER | Yes | ||
| SHIP_FRM_SD_AUTHORIZATION_ID | VARCHAR2 | (30) | ||
| DIST_BY_BUSINESS_NAME | VARCHAR2 | (240) | Yes | |
| 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 | (0) | ||
| 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 | VARCHAR2 | (0) | ||
| SHIP_TO_GBL_LOC_ID | VARCHAR2 | (0) | ||
| 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 | (0) | ||
| 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 | VARCHAR2 | (0) | ||
| SOLD_TO_GBL_LOC_ID | VARCHAR2 | (0) | ||
| 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 | (0) | ||
| 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 | VARCHAR2 | (0) | ||
| USED_BY_GBL_LOC_ID | VARCHAR2 | (0) | ||
| 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) | Yes | |
| CREDIT_REFERENCE_ID | VARCHAR2 | (0) | ||
| DEBIT_REFERENCE_ID | VARCHAR2 | (30) | ||
| GBL_DOC_REF_TYPE_CODE_BATCH | VARCHAR2 | (4000) | ||
| BATCH_LINE_NUMBER | NUMBER | Yes | ||
| GBL_DOC_REF_TYPE_CODE_ORDER | VARCHAR2 | (4000) | ||
| ORDER_DATE | DATE | Yes | ||
| ORDER_LINE_NUMBER | NUMBER | Yes | ||
| ORDER_NUMBER | NUMBER | Yes | ||
| GBL_DOC_REF_TYPE_CODE_INVOICE | VARCHAR2 | (4000) | ||
| INVOICE_DATE | DATE | |||
| INVOICE_LINE_NUMBER | NUMBER | |||
| INVOICE_NUMBER | NUMBER | (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 | |||
| 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 | (0) | ||
| VENDOR_AUTH_COST_MONETARY_AMT | VARCHAR2 | (0) | ||
| BATCH_SUBMISSION_DATE | DATE | |||
| BATCH_LINE_ID | NUMBER | Yes | ||
| THIS_DOC_ID | NUMBER | Yes |
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
, GBL_PRICE_TYPE_CODE_LIST
, COST_CURRENCYCODE
, COST_MONETARY_AMOUNT
, GBL_PRICE_TYPE_CODE_AGREEMENT
, AUTH_COST_CURRENCY_CODE
, AUTH_COST_MONETARY_AMOUNT
, 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
, BATCH_SUBMISSION_DATE
, BATCH_LINE_ID
, THIS_DOC_ID
FROM APPS.OZF_SD_BATCH_INFO_V;
APPS
FND_GLOBAL
- show dependent code
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
MTL_SYSTEM_ITEMS_B_KFV
OE_ORDER_HEADERS_ALL
OE_ORDER_LINES_ALL
OZF_SD_BATCH_FROM_ROLE_V
OZF_SD_BATCH_HEADERS_ALL
OZF_SD_BATCH_LINES_ALL
OZF_SD_CONTACT_V
APPS
OZF_SD_BATCH_CONTENT_QUERY_V
|
|
|
|