Search Results suppliers
Here's a detailed description of the AP.AP_VENDOR_KEY_IND_ALL table in Oracle E-Business Suite (EBS) Accounts Payable module:
Table Name: AP_VENDOR_KEY_IND_ALL
Purpose:
- Stores vendor key indicator information
- Tracks additional vendor classification or attribute details
- Used for vendor segmentation and reporting
Key Columns:
1. VENDOR_KEY_IND_ID (Primary Key)
- Unique identifier for each vendor key indicator record
- Typically a sequential number
2. VENDOR_ID
- Links to the main vendor record in AP_SUPPLIERS
- Establishes relationship with specific vendor
3. KEY_INDICATOR_CODE
- Represents specific vendor classification or characteristic
- Examples might include vendor type, risk category, etc.
4. EFFECTIVE_DATE
- Start date when the key indicator becomes active
- Allows tracking of historical and current vendor classifications
5. EXPIRATION_DATE
- Optional end date for the specific key indicator
- Supports temporal tracking of vendor attributes
Additional Columns:
- LAST_UPDATE_DATE
- LAST_UPDATED_BY
- CREATION_DATE
- CREATED_BY
- LAST_UPDATE_LOGIN
Common Uses:
- Vendor risk assessment
- Compliance tracking
- Advanced vendor reporting
- Specialized vendor segmentation
Typical Implementation:
- Populated through vendor setup screens
- Can be updated via Oracle Forms or programmatically
Recommended Practices:
- Maintain data integrity
- Use meaningful key indicator codes
- Keep historical records for audit purposes
-
Lookup Type: ICX_CAT_SUPPLIER_ASSIGN_TYPE
12.1.1
product: ICX - Oracle iProcurement , meaning: Supplier Dimension Assignment Type Lookup , description: Lookup for Supplier Dimension's assignment types. ,
-
Lookup Type: ICX_CAT_SUPPLIER_ASSIGN_TYPE
12.2.2
product: ICX - Oracle iProcurement , meaning: Supplier Dimension Assignment Type Lookup , description: Lookup for Supplier Dimension's assignment types. ,
-
APPS.AP_AUTOSELECT_PKG dependencies on AP_SUPPLIERS
12.1.1
-
Lookup Type: JLBR_SPED_PARTIC_TYPES
12.2.2
product: JL - Latin America Localizations , meaning: JLBR_SPED_PARTIC_TYPES , description: Pre-defined list of Entities which can Represent Participants in EBS JL BR SPED ,
-
Concurrent Program: POXEURASC
12.1.1
execution_filename: PO_MGD_EURO_CP.Run_All_Vendor_Conversion , product: PO - Purchasing , user_name: Suppliers Conversion , description: Executable for Euro All Suppliers Conversion , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
-
Concurrent Program: POXEURASC
12.2.2
execution_filename: PO_MGD_EURO_CP.Run_All_Vendor_Conversion , product: PO - Purchasing , user_name: Suppliers Conversion , description: Executable for Euro All Suppliers Conversion , argument_method: Standard , enabled: No , execution_method: PL/SQL Stored Procedure ,
-
TABLE: AP.AP_VENDOR_KEY_IND_ALL
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_VENDOR_KEY_IND_ALL, object_name:AP_VENDOR_KEY_IND_ALL, status:VALID,
-
TABLE: AP.AP_VENDOR_KEY_IND_ALL
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_VENDOR_KEY_IND_ALL, object_name:AP_VENDOR_KEY_IND_ALL, status:VALID,
-
Lookup Type: PON_NOTIF_SUBSCRIPTIONS
12.2.2
product: PON - Sourcing , meaning: Notification Groups Definition , description: Notification Groups Definition ,
-
APPS.POA_PORTAL_POPULATE_C dependencies on POA_PORTAL_RISK_SUMMARY
12.1.1
-
Lookup Type: MSD_DIM_ALL_DESC
12.2.2
product: MSD - Demand Planning , meaning: MSD_DIM_ALL_DESC , description: All dimension levels descriptions ,
-
Lookup Type: MSD_DIM_ALL_DESC
12.1.1
product: MSD - Demand Planning , meaning: MSD_DIM_ALL_DESC , description: All dimension levels descriptions ,
-
TABLE: AP.AP_PRODUCT_SETUP
12.2.2
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PRODUCT_SETUP, object_name:AP_PRODUCT_SETUP, status:VALID,
-
Lookup Type: PON_NOTIF_SUBSCRIPTIONS
12.1.1
product: PON - Sourcing , meaning: Notification Groups Definition , description: Notification Groups Definition ,
-
Lookup Type: POA_RISK_STATUS
12.1.1
product: POA - Purchasing Intelligence , meaning: Risk Status Categories , description: Risk Status Categories ,
-
Lookup Type: POA_RISK_STATUS
12.2.2
product: POA - Purchasing Intelligence (Obsolete) , meaning: Risk Status Categories , description: Risk Status Categories ,
-
TABLE: AP.AP_PRODUCT_SETUP
12.1.1
owner:AP, object_type:TABLE, fnd_design_data:SQLAP.AP_PRODUCT_SETUP, object_name:AP_PRODUCT_SETUP, status:VALID,
-
APPS.AP_AUTOSELECT_PKG dependencies on AP_SUPPLIERS
12.2.2
-
Concurrent Program: APXVDVSR
12.1.1
execution_filename: APXVDVSR , product: AP - Payables , user_name: APXVDVSR , description: Suppliers Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: APXVDVSR
12.2.2
execution_filename: APXVDVSR , product: AP - Payables , user_name: APXVDVSR , description: Suppliers Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Concurrent Program: FVSUPDAR
12.1.1
execution_filename: FVSUPDAR , product: FV - Federal Financials , user_name: FVSUPDAR , description: Suppliers Deactivation Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
Lookup Type: PON_SUPPLIER_VIEW_TYPE
12.1.1
product: PON - Sourcing , meaning: PON: Supplier View Type , description: PON: Suppliers see their bid price transformed or not ,
-
Lookup Type: PON_SUPPLIER_VIEW_TYPE
12.2.2
product: PON - Sourcing , meaning: PON: Supplier View Type , description: PON: Suppliers see their bid price transformed or not ,
-
Concurrent Program: FVSUPDAR
12.2.2
execution_filename: FVSUPDAR , product: FV - Federal Financials , user_name: FVSUPDAR , description: Suppliers Deactivation Report , argument_method: Standard , enabled: Yes , execution_method: Oracle Reports ,
-
APPS.POS_LOWER_BANNER_SV dependencies on HTP
12.2.2
-
APPS.POS_LOWER_BANNER_SV dependencies on HTP
12.1.1
-
APPS.IBY_PAYGROUP_PUB dependencies on PER_PEOPLE_X
12.1.1
-
APPS.AP_VENDORS_PKG dependencies on DUAL
12.2.2
-
APPS.AP_VENDORS_PKG dependencies on DUAL
12.1.1
-
APPS.AP_AUTOSELECT_PKG dependencies on AP_SUPPLIER_SITES_ALL
12.1.1
-
Concurrent Program: JEPTAPVR_XMLP
12.1.1
product: JE - European Localizations , user_name: Portuguese Suppliers Recapitulative Report , description: Portuguese Suppliers Recapitulative Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
-
Concurrent Program: APCHECKPAYSUPRPT
12.1.1
product: AP - Payables , user_name: AP Check Payments to Suppliers , description: AP Check Payments to Suppliers , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
-
Concurrent Program: APCHECKPAYSUPRPT
12.2.2
product: AP - Payables , user_name: AP Check Payments to Suppliers , description: AP Check Payments to Suppliers , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
-
Concurrent Program: APXVDVSR_XML
12.2.2
product: AP - Payables , user_name: Suppliers Report (XML) - Not Supported: Reserved For Future Use , description: Suppliers Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
-
Concurrent Program: APXVDVSR_XML
12.1.1
product: AP - Payables , user_name: Suppliers Report (XML) - Not Supported: Reserved For Future Use , description: Suppliers Report , argument_method: Standard , enabled: No , execution_method: Java Concurrent Program ,
-
Lookup Type: TIN_RPT_TIN_STATUS
12.1.1
product: FV - Federal Financials , meaning: Tin Report TIN Status ,
-
Lookup Type: TIN_RPT_TIN_STATUS
12.2.2
product: FV - Federal Financials , meaning: Tin Report TIN Status ,
-
Lookup Type: MSC_RP_FAVORITE_TYPE
12.2.2
product: MSC - Advanced Supply Chain Planning , meaning: Rapid Planning Favorite Types , description: Rapid Planning Favorite Types ,
-
APPS.PO_VERIFY_VENDOR_ELIGIBILITY dependencies on PON_BIDDING_PARTIES
12.2.2
-
Lookup Type: MTL_AUTHORIZED_VENDOR
12.1.1
product: INV - Inventory , meaning: MTL AUTHORIZED VENDOR ,
-
Lookup Type: MTL_AUTHORIZED_VENDOR
12.2.2
product: INV - Inventory , meaning: MTL AUTHORIZED VENDOR ,
-
Concurrent Program: JEPTAPVR_XMLP
12.2.2
product: JE - European Localizations , user_name: Portuguese Suppliers Recapitulative Report , description: Portuguese Suppliers Recapitulative Report , argument_method: Standard , enabled: Yes , execution_method: Java Concurrent Program ,
-
Lookup Type: DK_DATA_SUPPLIER_TYPE
12.1.1
product: PER - Human Resources , meaning: Organization Classifications that can be Data Suppliers. , description: Organization Classifications that can be Data Suppliers in Denmark. ,
-
Lookup Type: ZX_DETAILS_FOR_PARTIES_IN_TRX
12.1.1
product: ZX - E-Business Tax , meaning: Enter the details for the Parties involved in transactions , description: Enter the details for the Parties involved in transactions ,
-
Concurrent Program: JEITAPAA
12.2.2
execution_filename: JEITAPAA , product: JE - European Localizations , user_name: JEITAPAA , description: Italian AP VAT Register of Suppliers , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Lookup Type: POS_IMP_SUPPORTED_ENTITIES
12.2.2
product: POS - iSupplier Portal , meaning: Supplier Import entities ,
-
Concurrent Program: JEPTAPVR
12.2.2
execution_filename: JEPTAPVR , product: JE - European Localizations , user_name: JEPTAPVR , description: AP VAT Recapitulative Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Concurrent Program: JEPTAPVR
12.1.1
execution_filename: JEPTAPVR , product: JE - European Localizations , user_name: JEPTAPVR , description: AP VAT Recapitulative Report , argument_method: Standard , enabled: No , execution_method: Oracle Reports ,
-
Lookup Type: IGI_CIS2007_SUPR_SORT_COLS
12.2.2
product: IGI - Public Sector Financials International , meaning: CIS : Registered Suppliers Listing Report Sort Columns , description: Construction Industry Scheme : Registered Suppliers Listing Report Sort Columns ,
-
Concurrent Program: JEPTAPVE
12.2.2
execution_filename: JEPTAPVE , product: JE - European Localizations , user_name: JEPTAPVE , description: AP VAT Recapitulative Extract File , argument_method: Standard , enabled: No , execution_method: SQL*Plus ,