QA Views (93)

QA - Quality — documented views from Oracle EBS ETRM 12.2.2. Click any name for its documentation, columns and AI summary.

ViewDescription
QABV_COLELMACTN - Retrofitted
QABV_COLELMACTT - Retrofitted
QABV_COLLECTION_ELEMENTS - Retrofitted
QABV_COLLECTION_PLANS - Retrofitted
QABV_COLLECTION_PLAN_ELEMENTS - Retrofitted
QABV_COLPLNELAC - Retrofitted
QABV_COLPLNTXN - Retrofitted
QABV_COLPLNTXNT - Retrofitted
QABV_PLNELMACTT - Retrofitted
QABV_QUALITY_ACTION_TYPES - Retrofitted
QABV_QUALITY_SPECIFICATIONS - Retrofitted
QABV_QUALSPCELM - Retrofitted
QAFV_COLELMACTN - Retrofitted
QAFV_COLELMACTT - Retrofitted
QAFV_COLLECTION_ELEMENTS - Retrofitted
QAFV_COLLECTION_PLANS - Retrofitted
QAFV_COLLECTION_PLAN_ELEMENTS - Retrofitted
QAFV_COLPLNELAC - Retrofitted
QAFV_COLPLNTXN - Retrofitted
QAFV_COLPLNTXNT - Retrofitted
QAFV_PLNELMACTT - Retrofitted
QAFV_QUALITY_ACTION_TYPES - Retrofitted
QAFV_QUALITY_SPECIFICATIONS - Retrofitted
QAFV_QUALSPCELM - Retrofitted
QA_ACTION_LOG_V shows the action log
QA_BIS_RESULTS_V BIS Summary Table View
QA_CHARS_V This view shows the Collection elements information.
QA_CHAR_ACTIONS_V shows collection elements and actions
QA_CHAR_ACTION_OUTPUTS_V Shows output tokens defined for actions
QA_CHAR_ACTION_TRIGGERS_V Shows action triggers
QA_CHAR_VALUE_LOOKUPS_V Shows values assigned to collection element
QA_COLLECTION_PLAN_VIEWS_V Collection Plan Views allow you to query and inspect Quality result data for a particular collection plan in the Quality data repository.
QA_CRITERIA_HEADERS_V Shows chart and Quality Dynamic Reportwriter settings
QA_CRITERIA_V Shows collection plan , elements and chart and Quality Dynamic Reportwriter criterias
QA_CRITERIA_V1 Shows chart and Quality Dynamic Reportwriter criterias
QA_CUSTOMERS_LOV_V Customer collection element LOV validation view.
QA_DEVICE_DATA_VALUES_V
QA_ERES_INTEGRATION_PLANS_V Top level plans and collection IDs for electronic records
QA_ERES_PC_RESULTS_REL_V parent child relationships for electronic records
QA_ERES_PLANS_V All plans for electronic records
QA_ERES_PLAN_CHAR_ACTIONS_V plan element actions view for electronic records
QA_ERES_RCV_TRANS_INTERFACE_V electronic record view for receiving transaction integration
QA_ERES_SPECS_V specification view for electronic records
QA_ERES_WSH_DELIVERABLES_V shipping electronic record
QA_ERES_WSH_NEW_DELIVERIES_V shipping delivery electronic record
QA_GLOBAL_RESULTS_V Global view used in BIS workbook.
QA_GRANTED_PRIVILEGES_V This is the view corresponding to QA_GRANTED_PRIVILEGES
QA_GROUP_V TCA Groups for data security
QA_HZ_PARTY_RELATIONSHIPS_V TCA obsoleted the hz_party_relationships view in R12. This is a replacement to help make the uptake easier.
QA_IN_LISTS_V Shows values used in inlist operator
QA_LOOKUPS Standard AOL lookup view
QA_MQA_COLLECTION_TRIGGERS_V View to qa_txn_collection_triggers for mobile application convenience
QA_PC_CRITERIA_COLUMNS_V This view is for getting all elements that form the criteria elements of current plan.
QA_PC_PLAN_COLUMNS_V This view will be useful in getting all elements and values from current form so that these can be passed on to child plans.
QA_PC_RESULTS_RELATIONSHIP_V Parent/child relationship view
QA_PC_RESULT_COLUMNS_V This view will be useful in dealing with copy relationship or others.
QA_PLANS_V Shows all collection plans
QA_PLANS_VAL_V Shows valid collection plans
QA_PLAN_CHARS_V Shows collection plan and collection elements
QA_PLAN_CHAR_ACTIONS_V Shows collection plan , elements and actions
QA_PLAN_CHAR_ACTION_OUTPUTS_V Shows collection plans, elements , action and tokens
QA_PLAN_CHAR_ACTION_TRIGGERS_V Shows collection plan , elements and action triggers
QA_PLAN_COLLECTION_TRIGGERS_V shows collection plans and triggers associated
QA_PLAN_TRANSACTIONS_V Shows collection plan and Quality Collection transaction information
QA_PO_NUMBERS_LOV_V PO Number collection element LOV validation view.
QA_RESULTS_FULL_V Shows all quality results
QA_RESULTS_QWB_V Shows all quality results
QA_RESULTS_V Shows all quality results
QA_RESULTS_VAL_V Shows only valid quality results
QA_SALES_ORDERS_LOV_V Sales Order LOV record group
QA_SAMPLING_PLANS_V Sampling plans
QA_SAMPLING_RCV_CRITERIA_V Sampling criteria for Receiving
QA_SAMPLING_RCV_CRITERIA_VAL_V Valid Sampling criteria for Receiving
QA_SEQ_AUDIT_HISTORY_V sequence audit table
QA_SKIPLOT_PLAN_STATE_V Skip Lot plan state
QA_SKIPLOT_PROCESSES_V Valid Skip Lot Criteria for Receiving
QA_SKIPLOT_PROCESS_PLANS_V Skip Lot process plans
QA_SKIPLOT_RCV_CRITERIA_V Skip Lot criteria for Receiving
QA_SKIPLOT_RCV_CRITERIA_VAL_V Valid Skip Lot criteria for Receiving
QA_SKIPLOT_RCV_RESULTS_V Skip Lot results for Receiving
QA_SKIPLOT_STATE_HISTORY_V Skip Lot state history
QA_SL_CRITERIA_ASSOCIATION_V Skip Lot association to criteria header
QA_SL_SP_RCV_CRITERIA_ALL_V All Skip Lot/Sampling Criteria for Receiving
QA_SL_SP_RCV_CRITERIA_V Skip Lot/Sampling Criteria for Receiving
QA_SPECS_V Shows all specifications
QA_SPECS_VAL_V Shows valid specifications
QA_SPEC_CHARS_V Shows specification and collection elements
QA_SPEC_CHARS_VAL_V Shows specification and collection elements
QA_SPEC_ORGS_V Auxiliary view used by qa_spec_org_assignments_v
QA_SPEC_ORG_ASSIGNMENTS_V View used in spec org assignment window
QA_SP_CRITERIA_ASSOCIATION_V Sampling association with criteria header in the criteria setup form
QA_TXN_COLLECTION_TRIGGERS_V Shows collection triggers for Quality Collection transactions
QA_USER_GROUP_V FND user to TCA group association used in data security