DBA Data[Home] [Help]

APPS.GML_READ_IC_B SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 31

       SELECT nvl(ont_pricing_qty_source,0)
       FROM  ic_item_mst_b
       WHERE delete_mark = 0
       AND   item_no in (SELECT segment1
         	FROM mtl_system_items
     	WHERE organization_id   = discrete_org_id
          AND   inventory_item_id = discrete_item_id);