APPS.GMD_SPEC_MATCH_API SQL Statements

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

Line: 51

    Select header_id
       ,   ship_to_org_id             ship_to_site_id
       ,   sold_to_org_id             customer_id
       ,   ship_from_org_id           organization_id
       ,   inventory_item_id
       ,   schedule_ship_date
       ,   preferred_grade
    From oe_order_lines_all
    Where line_id = p_source_line_id
    ;

Line: 62

    SELECT meaning
    FROM   gem_lookups
    WHERE  lookup_type = 'GMD_QC_SPEC_MATCH_TYPES'
        AND lookup_code = l_spec_match_type;*/