[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | OZF_SD_BATCH_CONTENT_QUERY_V |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Used in WebADI to retrieve the ship and debit batch details
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_NUMBER | VARCHAR2 | (30) | Yes | Batch Number |
| OPERATING_UNIT | NUMBER | Operating Unit | ||
| FRM_CONTACT1_NAME | VARCHAR2 | (360) | Distributor Contact name | |
| FRM_CONTACT1_EMAIL | VARCHAR2 | (2000) | Distributor Contact email | |
| FRM_CONTACT1_FAX | VARCHAR2 | (0) | Distributor Contact fax | |
| FRM_CONTACT1_PHONE | VARCHAR2 | (2000) | Distributor Contact phone | |
| FRM_GBL_PTNR_ROLE_CLASS_CD | VARCHAR2 | (4000) | Partner Role classification code | |
| FRM_GBL_BUSINESS_ID | CHAR | (9) | Global Business Identifier | |
| FRM_GBL_SUPPLY_CHAIN_CD | VARCHAR2 | (30) | Global Supply Chain Code | |
| FRM_BUSINESS_NAME | VARCHAR2 | (240) | Yes | Name of a business entity sending feed |
| FRM_PROP_BUSINESS_ID | VARCHAR2 | (0) | Business identifier assigned and administered by a private authority | |
| FRM_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| FRM_PROP_AUTH_ID1 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| FRM_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partner's function in the supply chain | |
| FRM_CONTACT2_NAME | VARCHAR2 | (360) | Distributor Name | |
| FRM_CONTACT2_EMAIL | VARCHAR2 | (2000) | Distributor Email | |
| FRM_CONTACT2_FAX | VARCHAR2 | (0) | Distributor Fax | |
| FRM_CONTACT2_PHONE | VARCHAR2 | (2000) | Distributor Phone | |
| FRM_GBL_LOC_ID | VARCHAR2 | (60) | Global Location Identifer | |
| FRM_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | A descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| FRM_PROP_AUTH_ID2 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| FRM_PROP_LOC_ID | VARCHAR2 | (0) | Location identifier assigned and administered by a private authority | |
| FRM_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| FRM_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| FRM_ADD_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| FRM_CITY | VARCHAR2 | (30) | City name | |
| FRM_COUNTRY | VARCHAR2 | (60) | Country code | |
| FRM_POSTAL_CODE | VARCHAR2 | (30) | Zip code | |
| FRM_BOX_ID | VARCHAR2 | (30) | PO Box Identifier | |
| FRM_STATE_REGION | VARCHAR2 | (120) | Name of a state or province within a country | |
| GBL_DOC_FUNC_CD | VARCHAR2 | (4000) | Code identifying the function of a document as either a request or a response | |
| SHIP_FRM_SD_AUTHORIZATION_ID | VARCHAR2 | (30) | Identification number assigned to an approved Ship From Stock and Debit Authorization request by Vendor | |
| DIST_BY_GBL_BUSINESS_ID | CHAR | (9) | Business identifier. The DUNS number is specified by RosettaNet | |
| DIST_BY_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (30) | Global Supply Chain Code | |
| DIST_BY_BUSINESS_NAME | VARCHAR2 | (240) | Name of a business entity | |
| DIST_BY_PROP_BUSINESS_ID | VARCHAR2 | (0) | Business identifier assigned and administered by a private authority | |
| DIST_BY_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| DIST_BY_PROP_AUTH_ID1 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| DIST_BY_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partners function in the supply chain | |
| DIST_BY_CONTACT1_NAME | VARCHAR2 | (360) | Distributor contact name | |
| DIST_BY_CONTACT1_EMAIL | VARCHAR2 | (2000) | Distributor contact email | |
| DIST_BY_CONTACT1_FAX | VARCHAR2 | (0) | Distributor contact fax | |
| DIST_BY_CONTACT1_PHONE | VARCHAR2 | (2000) | Distributor contact phone | |
| DIST_BY_GBL_LOCATION_ID | VARCHAR2 | (60) | Location Identifier | |
| DIST_BY_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| DIST_BY_PROP_IDAUTHORITY2 | VARCHAR2 | (0) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| DIST_BY_PROP_LOCATION_ID | VARCHAR2 | (0) | Location identifier assigned and administered by a private authority | |
| DIST_BY_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| DIST_BY_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| DIST_BY_ADD_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| DIST_BY_CITY_NAME | VARCHAR2 | (30) | City name of the Distributor | |
| DIST_BY_GBL_COUNTRY_CODE | VARCHAR2 | (60) | Country code of the distributor | |
| DIST_BY_NATIONAL_POSTAL_CODE | VARCHAR2 | (30) | Zip code | |
| DIST_BY_POBOX_ID | VARCHAR2 | (30) | Postbox number | |
| DIST_BY_REGION_NAME | VARCHAR2 | (120) | Name of a state or province within a country | |
| SHIP_TO_BUSINESS_NAME | VARCHAR2 | (360) | Name of a Business Entity | |
| SHIP_TO_GBL_BUSINESS_ID | NUMBER | Business identifier. The DUNS number is specified by RosettaNet | ||
| SHIP_TO_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (30) | Global Supply chain code | |
| SHIP_TO_PROP_BUSINESS_ID | VARCHAR2 | (30) | Business identifier assigned and administered by a private authority | |
| SHIP_TO_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SHIP_TO_PROP_ID_AUTHORITY1 | VARCHAR2 | (0) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SHIP_TO_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partners function in the supply chain | |
| SHIP_TO_CONTACT1_NAME | VARCHAR2 | (383) | Ship to contact name | |
| SHIP_TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Ship to contact email | |
| SHIP_TO_CONTACT1_FAX | VARCHAR2 | (0) | Ship to contact fax | |
| SHIP_TO_CONTACT1_PHONE | VARCHAR2 | (60) | Ship to contact phone | |
| SHIP_TO_GBL_LOC_ID | VARCHAR2 | (240) | Location Identifier | |
| SHIP_TO_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SHIP_TO_PROP_ID_AUTHORITY2 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SHIP_TO_PROP_LOC_ID | NUMBER | (15) | Location identifier assigned and administered by a private authority | |
| SHIP_TO_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| SHIP_TO_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| SHIP_TO_ADD_LINE3 | VARCHAR2 | (481) | Third line of physical address | |
| SHIP_TO_CITY_NAME | VARCHAR2 | (60) | City name | |
| SHIP_TO_GBL_COUNTRY_CODE | VARCHAR2 | (60) | Country code | |
| SHIP_TO_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | National Postal Code | |
| SHIP_TO_POBOX_ID | VARCHAR2 | (50) | Postbox number | |
| SHIP_TO_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| SOLD_TO_BUSINESS_NAME | VARCHAR2 | (360) | Name of a business entity | |
| SOLD_TO_GBL_BUSINESS_ID | NUMBER | Business identifier. The DUNS number is specified by RosettaNet | ||
| SOLD_TO_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (30) | Global Supply Chain Code | |
| SOLD_TO_PROP_BUSINESS_ID | VARCHAR2 | (30) | Business identifier assigned and administered by a private authority | |
| SOLD_TO_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SOLD_TO_PROP_ID_AUTHORITY1 | VARCHAR2 | (0) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SOLD_TO_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partners function in the supply chain | |
| SOLD_TO_CONTACT1_NAME | VARCHAR2 | (383) | Sold to contact name | |
| SOLD_TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Sold to contact email | |
| SOLD_TO_CONTACT1_FAX | VARCHAR2 | (0) | Sold to contact fax | |
| SOLD_TO_CONTACT1_PHONE | VARCHAR2 | (60) | Sold to contact phone | |
| SOLD_TO_GBL_LOC_ID | VARCHAR2 | (240) | Location Identifier | |
| SOLD_TO_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| SOLD_TO_PROP_ID_AUTHORITY2 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| SOLD_TO_PROP_LOC_ID | NUMBER | (15) | Location identifier assigned and administered by a private authority | |
| SOLD_TO_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| SOLD_TO_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| SOLD_TO_ADD_LINE3 | VARCHAR2 | (481) | Third line of physical address | |
| SOLD_TO_CITY_NAME | VARCHAR2 | (60) | City name | |
| SOLD_TO_GBL_COUNTRY_CODE | VARCHAR2 | (60) | Country code | |
| SOLD_TO_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| SOLD_TO_POBOX_ID | VARCHAR2 | (50) | PO Box Identifier | |
| SOLD_TO_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| USED_BY_BUSINESS_NAME | VARCHAR2 | (360) | Name of a business entity | |
| USED_BY_GBL_BUSINESS_ID | NUMBER | Business identifier. The DUNS number is specified by RosettaNet | ||
| USED_BY_GBL_SUPPLY_CHAIN_CODE | VARCHAR2 | (30) | Global Supply Chain Code | |
| USED_BY_PROP_BUSINESS_ID | VARCHAR2 | (30) | Business identifier assigned and administered by a private authority | |
| USED_BY_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| USED_BY_PROP_ID_AUTHORITY1 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| USED_BY_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partners function in the supply chain | |
| USED_BY_CONTACT1_NAME | VARCHAR2 | (383) | End customer contact name | |
| USED_BY_CONTACT1_EMAIL | VARCHAR2 | (2000) | End customer contact email | |
| USED_BY_CONTACT1_FAX | VARCHAR2 | (0) | End customer contact fax | |
| USED_BY_CONTACT1_PHONE | VARCHAR2 | (60) | End customer contact phone | |
| USED_BY_GBL_LOC_ID | VARCHAR2 | (240) | Location Identifier | |
| USED_BY_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| USED_BY_PROP_ID_AUTHORITY2 | VARCHAR2 | (0) | Name that identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| USED_BY_PROP_LOC_ID | NUMBER | (15) | Location identifier assigned and administered by a private authority | |
| USED_BY_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| USED_BY_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| USED_BY_ADD_LINE3 | VARCHAR2 | (481) | Third line of physical address | |
| USED_BY_CITY_NAME | VARCHAR2 | (60) | City name | |
| USED_BY_GBL_COUNTRY_CODE | VARCHAR2 | (60) | Country code | |
| USED_BY_NATIONAL_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| USED_BY_POBOX_ID | VARCHAR2 | (0) | Postbox number | |
| USED_BY_REGION_NAME | VARCHAR2 | (60) | Name of a state or province within a country | |
| SHIP_FRM_SD_CLAIM_REQUEST_DATE | VARCHAR2 | (0) | Requesting Document transmission date | |
| SHIP_FRM_SD_CLAIM_REQUEST_ID | VARCHAR2 | (0) | Requesting Document Identifier | |
| CREDIT_REF_ID | VARCHAR2 | (0) | Vendor assigned number. | |
| DEBIT_REF_ID | VARCHAR2 | (30) | Claim Number sent in request | |
| BATCH_LINE_ID | NUMBER | Batch Line Identifer | ||
| BATCH_LINE_NUMBER | NUMBER | Batch line number | ||
| ORDER_DATE | DATE | Order date | ||
| ORDER_LINE_NUMBER | VARCHAR2 | (40) | Order line number | |
| ORDER_NUMBER | VARCHAR2 | (50) | Order number | |
| INVOICE_DATE | DATE | Invoice date | ||
| INVOICE_LINE_NUMBER | VARCHAR2 | (40) | Invoice Line number | |
| INVOICE_NUMBER | VARCHAR2 | (50) | Invoice number | |
| DISCOUNT_TYPE | VARCHAR2 | (30) | ||
| DISCOUNT_VALUE | NUMBER | |||
| DISCOUNT_CURRENCY | VARCHAR2 | (15) | ||
| COST_CURRENCYCODE | VARCHAR2 | (15) | Purchase price currency | |
| COST_MONETARY_AMOUNT | NUMBER | Purchase price | ||
| AUTH_COST_CURRENCY_CODE | VARCHAR2 | (15) | Agreement Price Currency | |
| AUTH_COST_MONETARY_AMOUNT | NUMBER | Agreement Price | ||
| RESALE_CURRENCY_CODE | VARCHAR2 | (15) | Resale price currency code | |
| RESALE_MONETARY_AMOUNT | NUMBER | Resale price | ||
| GBL_UOM | VARCHAR2 | (3) | Unit of measure | |
| GBL_CLAIM_DISPOSITION_CODE | VARCHAR2 | (0) | Line Status | |
| DISPUTE_CODE1 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE2 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE3 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE4 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE5 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE6 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE7 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE8 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE9 | VARCHAR2 | (0) | Line Rejection code | |
| DISPUTE_CODE10 | VARCHAR2 | (0) | Line Rejection code | |
| VENDOR_PRODUCT_ID | VARCHAR2 | (240) | Vendor product code | |
| DIST_PRODUCT_ID | VARCHAR2 | (40) | Distributor product code | |
| SHIP_DATE | DATE | Shipment date | ||
| SHIPPED_QUANTITY | NUMBER | Quantity Shipped | ||
| LAST_SUB_CLAIM_AMOUNT | NUMBER | Claim amount during last submission | ||
| CLAIM_AMOUNT_CURRENCY_CODE | VARCHAR2 | (15) | Currency code of claim amount during last submission | |
| SUPP_AUTH_LINE_ITEM_NUMBER | VARCHAR2 | (0) | A unique Authorization number provided by the vendor for each line item | |
| VENDOR_AUTH_COST_CURRENCY_CODE | VARCHAR2 | (15) | Vendor authorised amount currency | |
| VENDOR_AUTH_COST_MONETARY_AMT | VARCHAR2 | (0) | Vendor authorised amount | |
| VENDOR_AUTH_QTY | VARCHAR2 | (0) | Vendor Authorised Quantity | |
| BATCH_SUBMISSION_DATE | DATE | Date on which batch was submitted to the vendor for Approval | ||
| BATCH_ID | NUMBER | Yes | Batch ID | |
| TO_CONTACT1_NAME | VARCHAR2 | (360) | Transmission recipient contact name | |
| TO_CONTACT1_EMAIL | VARCHAR2 | (2000) | Transmission recipient contact email | |
| TO_CONTACT1_FAX | VARCHAR2 | (60) | Transmission recipient contact fax | |
| TO_CONTACT1_PHONE | VARCHAR2 | (60) | Transmission recipient contact phone | |
| TO_GBL_PTNR_ROLE_CLASS_CD | VARCHAR2 | (4000) | Partner Role classification code | |
| TO_GBL_BUSINESS_ID | VARCHAR2 | (30) | Business identifier. The DUNS number is specified by RosettaNet | |
| TO_GBL_SUPPLY_CHAIN_CD | VARCHAR2 | (30) | Global Supply Chain Code | |
| TO_BUSINESS_NAME | VARCHAR2 | (240) | Business name | |
| TO_PROP_BUSINESS_ID | VARCHAR2 | (0) | Business identifier assigned and administered by a private authority | |
| TO_PROP_DOMAIN_ID1 | VARCHAR2 | (0) | Descriptor used to categorize an organization or business entity in the Proprietary Business Identifier | |
| TO_PROP_AUTH_ID1 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| TO_GBL_PTNR_CLASS_CODE | VARCHAR2 | (4000) | Code identifying a partner's function in the supply chain | |
| TO_CONTACT2_NAME | VARCHAR2 | (360) | Supplier Contact name | |
| TO_CONTACT2_EMAIL | VARCHAR2 | (2000) | Supplier Contact email | |
| TO_CONTACT2_FAX | VARCHAR2 | (60) | Supplier Contact fax | |
| TO_CONTACT2_PHONE | VARCHAR2 | (60) | Supplier Contact phone | |
| TO_GBL_LOC_ID | VARCHAR2 | (15) | Yes | Location identifier |
| TO_PROP_DOMAIN_ID2 | VARCHAR2 | (0) | Descriptor to categorize an organization or business entity in the Proprietary Business Identifier | |
| TO_PROP_AUTH_ID2 | VARCHAR2 | (0) | Identifies an organization or business entity responsible for managing one or more lists of identifiers | |
| TO_PROP_LOC_ID | VARCHAR2 | (0) | Location identifier assigned and administered by a private authority | |
| TO_ADD_LINE1 | VARCHAR2 | (240) | First line of physical address | |
| TO_ADD_LINE2 | VARCHAR2 | (240) | Second line of physical address | |
| TO_ADD_LINE3 | VARCHAR2 | (240) | Third line of physical address | |
| TO_CITY | VARCHAR2 | (60) | City name | |
| TO_COUNTRY | VARCHAR2 | (60) | Country code | |
| TO_POSTAL_CODE | VARCHAR2 | (60) | Zip code | |
| TO_BOX_ID | VARCHAR2 | (60) | Postbox number | |
| TO_STATE_REGION | VARCHAR2 | (150) | Name of a state or province within a country | |
| 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) |
Cut, paste (and edit) the following text to query this object:
SELECT BATCH_NUMBER
, OPERATING_UNIT
, FRM_CONTACT1_NAME
, FRM_CONTACT1_EMAIL
, FRM_CONTACT1_FAX
, FRM_CONTACT1_PHONE
, FRM_GBL_PTNR_ROLE_CLASS_CD
, FRM_GBL_BUSINESS_ID
, FRM_GBL_SUPPLY_CHAIN_CD
, FRM_BUSINESS_NAME
, FRM_PROP_BUSINESS_ID
, FRM_PROP_DOMAIN_ID1
, FRM_PROP_AUTH_ID1
, FRM_GBL_PTNR_CLASS_CODE
, FRM_CONTACT2_NAME
, FRM_CONTACT2_EMAIL
, FRM_CONTACT2_FAX
, FRM_CONTACT2_PHONE
, FRM_GBL_LOC_ID
, FRM_PROP_DOMAIN_ID2
, FRM_PROP_AUTH_ID2
, FRM_PROP_LOC_ID
, FRM_ADD_LINE1
, FRM_ADD_LINE2
, FRM_ADD_LINE3
, FRM_CITY
, FRM_COUNTRY
, FRM_POSTAL_CODE
, FRM_BOX_ID
, FRM_STATE_REGION
, GBL_DOC_FUNC_CD
, SHIP_FRM_SD_AUTHORIZATION_ID
, DIST_BY_GBL_BUSINESS_ID
, DIST_BY_GBL_SUPPLY_CHAIN_CODE
, DIST_BY_BUSINESS_NAME
, DIST_BY_PROP_BUSINESS_ID
, DIST_BY_PROP_DOMAIN_ID1
, DIST_BY_PROP_AUTH_ID1
, DIST_BY_GBL_PTNR_CLASS_CODE
, DIST_BY_CONTACT1_NAME
, DIST_BY_CONTACT1_EMAIL
, DIST_BY_CONTACT1_FAX
, DIST_BY_CONTACT1_PHONE
, DIST_BY_GBL_LOCATION_ID
, DIST_BY_PROP_DOMAIN_ID2
, DIST_BY_PROP_IDAUTHORITY2
, DIST_BY_PROP_LOCATION_ID
, DIST_BY_ADD_LINE1
, DIST_BY_ADD_LINE2
, DIST_BY_ADD_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_GBL_PTNR_CLASS_CODE
, SHIP_TO_CONTACT1_NAME
, SHIP_TO_CONTACT1_EMAIL
, SHIP_TO_CONTACT1_FAX
, SHIP_TO_CONTACT1_PHONE
, SHIP_TO_GBL_LOC_ID
, SHIP_TO_PROP_DOMAIN_ID2
, SHIP_TO_PROP_ID_AUTHORITY2
, SHIP_TO_PROP_LOC_ID
, SHIP_TO_ADD_LINE1
, SHIP_TO_ADD_LINE2
, SHIP_TO_ADD_LINE3
, SHIP_TO_CITY_NAME
, SHIP_TO_GBL_COUNTRY_CODE
, SHIP_TO_NATIONAL_POSTAL_CODE
, SHIP_TO_POBOX_ID
, SHIP_TO_REGION_NAME
, 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_GBL_PTNR_CLASS_CODE
, SOLD_TO_CONTACT1_NAME
, SOLD_TO_CONTACT1_EMAIL
, SOLD_TO_CONTACT1_FAX
, SOLD_TO_CONTACT1_PHONE
, SOLD_TO_GBL_LOC_ID
, SOLD_TO_PROP_DOMAIN_ID2
, SOLD_TO_PROP_ID_AUTHORITY2
, SOLD_TO_PROP_LOC_ID
, SOLD_TO_ADD_LINE1
, SOLD_TO_ADD_LINE2
, SOLD_TO_ADD_LINE3
, SOLD_TO_CITY_NAME
, SOLD_TO_GBL_COUNTRY_CODE
, SOLD_TO_NATIONAL_POSTAL_CODE
, SOLD_TO_POBOX_ID
, SOLD_TO_REGION_NAME
, 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_GBL_PTNR_CLASS_CODE
, USED_BY_CONTACT1_NAME
, USED_BY_CONTACT1_EMAIL
, USED_BY_CONTACT1_FAX
, USED_BY_CONTACT1_PHONE
, USED_BY_GBL_LOC_ID
, USED_BY_PROP_DOMAIN_ID2
, USED_BY_PROP_ID_AUTHORITY2
, USED_BY_PROP_LOC_ID
, USED_BY_ADD_LINE1
, USED_BY_ADD_LINE2
, USED_BY_ADD_LINE3
, USED_BY_CITY_NAME
, USED_BY_GBL_COUNTRY_CODE
, USED_BY_NATIONAL_POSTAL_CODE
, USED_BY_POBOX_ID
, USED_BY_REGION_NAME
, SHIP_FRM_SD_CLAIM_REQUEST_DATE
, SHIP_FRM_SD_CLAIM_REQUEST_ID
, CREDIT_REF_ID
, DEBIT_REF_ID
, BATCH_LINE_ID
, BATCH_LINE_NUMBER
, ORDER_DATE
, ORDER_LINE_NUMBER
, ORDER_NUMBER
, INVOICE_DATE
, INVOICE_LINE_NUMBER
, INVOICE_NUMBER
, DISCOUNT_TYPE
, DISCOUNT_VALUE
, DISCOUNT_CURRENCY
, COST_CURRENCYCODE
, COST_MONETARY_AMOUNT
, AUTH_COST_CURRENCY_CODE
, AUTH_COST_MONETARY_AMOUNT
, 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
, VENDOR_PRODUCT_ID
, DIST_PRODUCT_ID
, SHIP_DATE
, SHIPPED_QUANTITY
, LAST_SUB_CLAIM_AMOUNT
, CLAIM_AMOUNT_CURRENCY_CODE
, SUPP_AUTH_LINE_ITEM_NUMBER
, VENDOR_AUTH_COST_CURRENCY_CODE
, VENDOR_AUTH_COST_MONETARY_AMT
, VENDOR_AUTH_QTY
, BATCH_SUBMISSION_DATE
, BATCH_ID
, TO_CONTACT1_NAME
, TO_CONTACT1_EMAIL
, TO_CONTACT1_FAX
, TO_CONTACT1_PHONE
, TO_GBL_PTNR_ROLE_CLASS_CD
, TO_GBL_BUSINESS_ID
, TO_GBL_SUPPLY_CHAIN_CD
, TO_BUSINESS_NAME
, TO_PROP_BUSINESS_ID
, TO_PROP_DOMAIN_ID1
, TO_PROP_AUTH_ID1
, TO_GBL_PTNR_CLASS_CODE
, TO_CONTACT2_NAME
, TO_CONTACT2_EMAIL
, TO_CONTACT2_FAX
, TO_CONTACT2_PHONE
, TO_GBL_LOC_ID
, TO_PROP_DOMAIN_ID2
, TO_PROP_AUTH_ID2
, TO_PROP_LOC_ID
, TO_ADD_LINE1
, TO_ADD_LINE2
, TO_ADD_LINE3
, TO_CITY
, TO_COUNTRY
, TO_POSTAL_CODE
, TO_BOX_ID
, TO_STATE_REGION
, 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_CONTENT_QUERY_V;
APPS
FND_MESSAGE
- show dependent code
OZF_SD_BATCH_FROM_ROLE_V
OZF_SD_BATCH_INFO_V
OZF_SD_BATCH_TO_ROLE_V
APPS.OZF_SD_BATCH_CONTENT_QUERY_V is not referenced by any database object
|
|
|
|