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), ) /