APPS.GME_BATCH_WKFL_PKG SQL Statements

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

Line: 16

 | --  Insert_gml_batch_so_workflow()                                      |
 |                                                                         |
 | HISTORY                                                                 |
 |              10-Oct-2003  nchekuri        Created                       |
 |                                                                         |
 +=========================================================================+ */

G_PKG_NAME  CONSTANT  VARCHAR2(30):='GME_BATCH_WORKFLOW_PKG';

Line: 63

     SELECT user_name
       FROM fnd_user
      WHERE user_id = p_user_id;

Line: 68

     SELECT  ol.line_number, mtl.segment1,
             ot.transaction_type_code,
             oh.order_number
       FROM  oe_order_headers_all oh
            ,oe_order_lines_all ol
            ,oe_transaction_types_all ot
            ,mtl_system_items mtl
      WHERE  ol.line_id = p_so_line_id
        and  ol.header_id = oh.header_id
        and  oh.order_type_id = ot.transaction_type_id
        and  mtl.inventory_item_id = ol.inventory_item_id;

Line: 81

      SELECT batch_no,plant_code,
             plan_cmplt_date
        FROM gme_batch_header
        WHERE batch_id = p_batch_id;

Line: 87

      SELECT line_no
        FROM gme_material_details
        WHERE material_detail_id = p_batch_line_id;

Line: 92

       Select organization_code
       From mtl_parameters
       Where organization_id = p_organization_id;