APPS.OE_ATP SQL Statements

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

Line: 133

       SELECT 1
       INTO   l_validity_flag
       FROM   mtl_system_items_b msi,
              org_organization_definitions org
       WHERE  msi.inventory_item_id= p_line_atp_rec.inventory_item_id
       AND    org.organization_id=msi.organization_id
       AND    sysdate<=nvl(org.disable_date,sysdate)
       AND    org.organization_id=p_line_atp_rec.ship_from_org_id
       AND    rownum=1;