+5
dear all,
i want to create new field in ifs10. how can i revised below query for read only select expression,
SELECT ipis.QTY_ONHAND - ipis.QTY_RESERVED eldeki_miktar fROM PURCHASE_ORDER_LINE_ALL pola RIGHT JOIN INVENTORY_PART_IN_STOCK_UIV ipis ON ipis.project_id = pola.:project_id AND ipis.part_no = pola.:part_no and ipis.activity_seq=pola.:ACTIVITY_SEQ and ipis.CONTRACT=pola.:CONTRACT
ps: Below is the screen where I will make this development.
Best answer by Buddhika Kurera
View original
+13
Query is modified to
SELECT sum(x.QTY_ONHAND - x.QTY_RESERVED) FROM INVENTORY_PART_IN_STOCK_UIV x WHERE x.CONTRACT=:SITE AND x.ACTIVITY_SEQ=:ACTIVITY_SEQ AND x.PART_NO =:PART_NO
The output of the custom field
Records in Inventory Part in Stock
Hope this helps !
+5
Query is modified to
SELECT sum(x.QTY_ONHAND - x.QTY_RESERVED) FROM INVENTORY_PART_IN_STOCK_UIV x WHERE x.CONTRACT=:SITE AND x.ACTIVITY_SEQ=:ACTIVITY_SEQ AND x.PART_NO =:PART_NO
The output of the custom field
Records in Inventory Part in Stock
Hope this helps !
thank you so much for the help.
+13
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.