Home/ Questions/Q 2563
In Process

vinish.ai Latest Questions

  • -1
  • -1
Asked: 2020-10-17T12:14:27+00:00

Crate LOV from Shared Components in Mapping

  • -1
  • -1

HI,

I have a following tables, which is used in order to be processed Sales activity. However, i am getting some problem while returning value from Lov.

First we enter the order which we receive from customer. After that we generate Sales Order either it can be dependent on Order or Not, if create order based sales invoice then select order number from list.

Now issue i want to select order# from list and the list should show order_num but behind the filed it should store order _id.

create table CUSTOMERS 
( CUSTOMER_ID NUMBER(6), 
CUSTTOMER_CODE VARCHAR2(30), 
NAME VARCHAR2(60))
create table INV_SORDER_MASTER ( 
BUSINESS_GROUP_ID NUMBER(3), 
ORDER_ID NUMBER, 
ORDER_NUM VARCHAR2(30), 
ORDER_DATE DATE, 
CUSTOMER_ID NUMBER(6) )
create table INV_SALES_INVOICE ( INVOICE_ID NUMBER, 
INV_NUM VARCHAR2(30), 
INV_DATE DATE, 
ORDER_ID NUMBER, 
CUSTOMER_ID NUMBER(6), 
PAYMENT_MODE VARCHAR2(1), 
AMOUNT NUMBER(12,2), 
REMARKS VARCHAR2(60), )
/
lovoracle apex
Share
Leave an answer

Leave an answer

Browse

2 Answers

  1. Thanks for you update on this.

  2. You want to show order_num and need to store order_id, right? If yes, then you can use the following query:

    select o.order_num d, s.order_id r
   from inv_sorder_master o, inv_sales_invoice s
 where o.order_id = s.order_id;

    Or if you want to filter the result based on the customer id, use the following query:

    select o.order_num d, s.order_id r
   from inv_sorder_master o, inv_sales_invoice s
where o.order_id = s.order_id
      and o.customer_id = :px_yourCustIDItem;

    Then add the item px_yourCustIDItem to items to submit and cascade lov items.