Adding LOV to Webadi

Adding LOV to the Webadi

BEGIN
BNE_INTEGRATOR_UTILS.CREATE_TABLE_LOV
  (P_APPLICATION_ID        => 20003,
   P_INTERFACE_CODE        => 'EXPDAPEGEINV_XINTG_INTF1',
   P_INTERFACE_COL_NAME    => 'P_PAY_AWT_GROUP_NAME',
  --Interface Column Name from where the user double clicks to open the LOV and P_ID_COL is also passed to this spreadsheet column.
  P_ID_COL                 => 'NAME',
  P_MEAN_COL               => 'NAME',
  P_DESC_COL               => 'DESCRIPTION',
  P_TABLE                  => '(select g.name name, description from ap_awt_groups g where exists (select 1 from ap_awt_group_taxes_all t where g.group_id= t.group_id) and nvl(inactive_date,sysdate+1) > sysdate order by name)',
  P_ADDL_W_C               => '1=1',
  P_WINDOW_CAPTION         => 'Group Name', --LOV window caption
  P_WINDOW_WIDTH           => 500, --Window Width. Optional.
  P_WINDOW_HEIGHT          => 400, --Window Height. Optional
  P_TABLE_BLOCK_SIZE       => 10, --Number of records to be displayed in the LOV
  P_TABLE_SORT_ORDER       => 'Yes', --Order to be displayed in LOV
  P_USER_ID                => 0,
  --FND User ID of the person who is creating this LOV.
  P_TABLE_COLUMNS          => 'Name,Description',
  --LOV fields to be displayed. Note person ID will not be displayed.
  P_TABLE_SELECT_COLUMNS   => 'P_PAY_AWT_GROUP_NAME', --EMPLOYEE_NUMBER(First value in P_TABLE_COLUMNS) is passed to this spreadsheet column and is displayed. PERSON_ID is passed to this same field as hidden value and is passed to the API when upload happens. If you want FULL_NAME etc also passed to the spereadsheet then mention that spreadsheet column(s) separated by commas
  P_TABLE_COLUMN_ALIAS     => NULL,
  P_TABLE_HEADERS          => 'Group Name, Description',
  P_POPLIST_FLAG           => 'N');
END;

Some time the Above API will not work due to the length issue. Then you can go and create the LOV manually.

Deleting LOV

delete from BNE_PARAM_LIST_ITEMS where PARAM_NAME = 'P_TDS_TAX_CATEGORY_ID'

delete from BNE_ATTRIBUTES  where ATTRIBUTE1 = 'P_TDS_TAX_CATEGORY_ID'

delete BNE_INTERFACE_COLS_B where creation_date like sysdate

delete BNE_INTERFACE_COLS_TL where creation_date like sysdate

Creating LOV from the Front End

Step 1:

Step 2:

Step 3:

Step 4:

Step 5:

Step 6:

Dependent LOV in webadi:

OPERATING_UNIT = $INTERFACE$.P_OPERATING_UNIT