POZ_SUPPLIERS is the table used by Oracle Fusion to store the data related to supplier. Supplier is someone you use to source the material or the services from, so it makes supplier one of the key entities in your business. So if you have implemented Purchasing/ Payables or P2P Cycle, it is inevitable that you will have to query the POZ_SUPPLIERS table. In this post we will talk about the table structure as well as the indexes present on this table in Oracle Fusion so that you can query the table more efficiently. But in case you are looking for the query to fetch the supplier details, this post may help you. Before we have a look at the structure, here are a few points to remember:
Navigation: Procurement –> Suppliers
1. Segment1 of the table holds the supplier number or the vendor number.
2. Party_Id is the column which links the table POZ_SUPPLIERS with HZ_PARTIES table. This link is critical as using it you will be able to find the supplier name ( Thanks to TCA architecture).
3. POZ_SUPPLIER_SITES_ALL_M is the child table which is used to store the supplier site details.
Want to give back to the society? (Do you have something which you think can be used by folks working on Oracle world wide?) Then Click here, share your email id and a brief description of the topic. And keep your photo and the content ready.
By the way, Here ( India) or Here ( Other Geographies) are few UNCONVENTIONAL tricks which I have learnt to improve the performance of BI reports. Try them only when nothing else works.. kind of SOS...
POZ_SUPPLIERS Columns
| COLUMN_NAME | DATA_TYPE | NULLABLE |
| VENDOR_ID | NUMBER | N |
| REVIEW_TYPE | VARCHAR2(120) | Y |
| OBJECT_VERSION_NUMBER | NUMBER | N |
| SEGMENT1 | VARCHAR2(120) | N |
| PARTY_ID | NUMBER | N |
| CREATION_SOURCE | VARCHAR2(100) | Y |
| ENABLED_FLAG | VARCHAR2(4) | Y |
| SUMMARY_FLAG | VARCHAR2(4) | Y |
| VENDOR_TYPE_LOOKUP_CODE | VARCHAR2(120) | Y |
| CUSTOMER_NUM | VARCHAR2(100) | Y |
| ONE_TIME_FLAG | VARCHAR2(4) | Y |
| EMPLOYEE_ID | NUMBER | Y |
| PARENT_PARTY_ID | NUMBER | Y |
| PARENT_VENDOR_ID | NUMBER | Y |
| MIN_ORDER_AMOUNT | NUMBER | Y |
| SET_OF_BOOKS_ID | NUMBER | Y |
| TYPE_1099 | VARCHAR2(40) | Y |
| WITHHOLDING_STATUS_LOOKUP_CODE | VARCHAR2(100) | Y |
| WITHHOLDING_START_DATE | DATE | Y |
| INCOME_TAX_ID_FLAG | VARCHAR2(4) | Y |
| NI_NUMBER_FLAG | VARCHAR2(4) | Y |
| ORGANIZATION_TYPE_LOOKUP_CODE | VARCHAR2(120) | Y |
| TAXPAYER_COUNTRY | VARCHAR2(8) | Y |
| START_DATE_ACTIVE | DATE | Y |
| END_DATE_ACTIVE | DATE | Y |
| MINORITY_GROUP_LOOKUP_CODE | VARCHAR2(100) | Y |
| WOMEN_OWNED_FLAG | VARCHAR2(4) | Y |
| SMALL_BUSINESS_FLAG | VARCHAR2(4) | Y |
| STANDARD_INDUSTRY_CLASS | VARCHAR2(100) | Y |
| TAX_VERIFICATION_DATE | DATE | Y |
| NAME_CONTROL | VARCHAR2(16) | Y |
| STATE_REPORTABLE_FLAG | VARCHAR2(4) | Y |
| FEDERAL_REPORTABLE_FLAG | VARCHAR2(4) | Y |
| TAX_REPORTING_NAME | VARCHAR2(320) | Y |
| ALLOW_AWT_FLAG | VARCHAR2(4) | Y |
| AWT_GROUP_ID | NUMBER | Y |
| BANK_CHARGE_BEARER | VARCHAR2(4) | Y |
| NI_NUMBER | VARCHAR2(120) | Y |
| BC_NOT_APPLICABLE_FLAG | VARCHAR2(4) | Y |
| EXTERNAL_SYSTEM_ID | NUMBER | Y |
| EXTERNAL_SYSTEM | VARCHAR2(360) | Y |
| LAST_UPDATE_DATE | TIMESTAMP(6) | N |
| LAST_UPDATED_BY | VARCHAR2(256) | N |
| LAST_UPDATE_LOGIN | VARCHAR2(128) | Y |
| CREATION_DATE | TIMESTAMP(6) | N |
| CREATED_BY | VARCHAR2(256) | N |
| REQUEST_ID | NUMBER | Y |
| JOB_DEFINITION_NAME | VARCHAR2(400) | Y |
| JOB_DEFINITION_PACKAGE | VARCHAR2(3600) | Y |
| PROGRAM_APPLICATION_ID | NUMBER | Y |
| PROGRAM_ID | NUMBER | Y |
| PROGRAM_UPDATE_DATE | DATE | Y |
| ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| ATTRIBUTE1 – ATTRIBUTE20 | VARCHAR2(600) | Y |
| ATTRIBUTE_DATE1- ATTRIBUTE_DATE10 | DATE | Y |
| ATTRIBUTE_TIMESTAMP1 – ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| ATTRIBUTE_NUMBER1 – ATTRIBUTE_NUMBER10 | NUMBER | Y |
| GLOBAL_ATTRIBUTE1 – GLOBAL_ATTRIBUTE20 | VARCHAR2(600) | Y |
| GLOBAL_ATTRIBUTE_DATE1 – GLOBAL_ATTRIBUTE_DATE10 | DATE | Y |
| GLOBAL_ATTRIBUTE_TIMESTAMP1 – GLOBAL_ATTRIBUTE_TIMESTAMP10 | TIMESTAMP(6) | Y |
| GLOBAL_ATTRIBUTE_NUMBER1 – GLOBAL_ATTRIBUTE_NUMBER10 | NUMBER | Y |
| GLOBAL_ATTRIBUTE_CATEGORY | VARCHAR2(120) | Y |
| AP_TAX_ROUNDING_RULE | VARCHAR2(4) | Y |
| AUTO_TAX_CALC_FLAG | VARCHAR2(4) | Y |
| AUTO_TAX_CALC_OVERRIDE | VARCHAR2(4) | Y |
| AMOUNT_INCLUDES_TAX_FLAG | VARCHAR2(4) | Y |
| OFFSET_TAX_FLAG | VARCHAR2(4) | Y |
| OFFSET_VAT_CODE | VARCHAR2(80) | Y |
| VAT_CODE | VARCHAR2(120) | Y |
| VAT_REGISTRATION_NUM | VARCHAR2(80) | Y |
| CORPORATE_WEBSITE | VARCHAR2(600) | Y |
| BUSINESS_RELATIONSHIP | VARCHAR2(120) | Y |
| SPEND_AUTH_JUSTIFICATION | VARCHAR2(4000) | Y |
| SPEND_AUTH_REVIEW_STATUS | VARCHAR2(120) | Y |
| SUPPLIER_LOCKED_FLAG | VARCHAR2(4) | Y |
| CHANGE_REQ_NUMBER | NUMBER | Y |
| REBUILD_INDEX | VARCHAR2(4) | Y |
| CREATED_BY_REST_FLAG | VARCHAR2(4) | Y |
| DATAFOX_COMPANY_ID | VARCHAR2(120) | Y |
Indexes
| INDEX_NAME | INDEX_TYPE | UNIQUENESS | COLUMN_NAME |
| POZ_SEARCH_INDEX | DOMAIN | NONUNIQUE | REBUILD_INDEX |
| POZ_SUPPLIERS_N2 | NORMAL | NONUNIQUE | PARENT_VENDOR_ID |
| POZ_SUPPLIERS_N3 | NORMAL | NONUNIQUE | PARENT_PARTY_ID |
| POZ_SUPPLIERS_N4 | NORMAL | NONUNIQUE | PARTY_ID |
| POZ_SUPPLIERS_N5 | FUNCTION-BASED NORMAL | NONUNIQUE | SYS_NC00170$ |
| POZ_SUPPLIERS_N6 | NORMAL | NONUNIQUE | LAST_UPDATE_DATE |
| POZ_SUPPLIERS_N7 | NORMAL | NONUNIQUE | TAXPAYER_COUNTRY |
| POZ_SUPPLIERS_N8 | NORMAL | NONUNIQUE | CREATION_DATE |
| POZ_SUPPLIERS_N9 | NORMAL | NONUNIQUE | DATAFOX_COMPANY_ID |
| POZ_SUPPLIERS_U1 | NORMAL | UNIQUE | VENDOR_ID |
| POZ_SUPPLIERS_U2 | NORMAL | UNIQUE | SEGMENT1 |
Related Posts
Supplier Detail Query
Supplier Site Query ( SQL) – General in Fusion
Vendor Site – Invoicing & Payments Query
Vendor Fiscal Classification Query in Oracle Fusion
Feedback:
Hope the article helped you. If it did, please rate the post. In case it didn’t, do leave a comment to let us know what did we miss.
Reference:
support.oracle.com
Check out the Amazon Deals of the day based on your interests..
1 thought on “POZ_SUPPLIERS: Supplier Table In Oracle Fusion”
Comments are closed.