Saturday, December 18, 2021

Query to extract values from the User Defined Tables in Oracle APPS

SELECT put.user_table_name
      ,pur.row_low_range_or_name
      ,pui.value
      ,puc.user_column_name
  FROM pay_user_tables put
      ,pay_user_rows_f pur
      ,pay_user_columns puc
      ,pay_user_column_instances_f pui
 WHERE 1=1
   AND pur.user_table_id = put.user_table_id
   AND pui.user_column_id = puc.user_column_id
   AND pui.user_row_id = pur.user_row_id
   AND SYSDATE BETWEEN pur.effective_start_date AND pur.effective_end_date
   AND SYSDATE BETWEEN pui.effective_start_date AND pui.effective_end_date
   --AND put.user_table_name = '<USER_DEFINED_TABLE_NAME>'
   --AND puc.user_column_name = '<USER_DEFINED_COLUMN_NAME>'
   AND puc.user_table_id = put.user_table_id

5 comments:

SupplierAddressImportTemplate.xlsm South Africa Suburb Field mapping in POZ_SUPPLIER_ADDRESSES_INT

Suburb mpping in Supplier Address Import Template will be mapped to Address Element Attribute2 (HZ_LOCATIONS. ADDR_ELEMENT_ATTRIBUTE2)