APPS.WMS_CROSSDOCK_GRP SQL Statements

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

Line: 46

       SELECT wcc.criterion_id
         FROM wms_crossdock_criteria  wcc
        WHERE wcc.criterion_id   = p_crt_id
          AND wcc.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

Line: 131

       SELECT wccv.criterion_name
         FROM wms_crossdock_criteria_vl  wccv
        WHERE wccv.criterion_id   = p_crt_id
          AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

Line: 139

       SELECT wccv.criterion_id
         FROM wms_crossdock_criteria_vl  wccv
        WHERE wccv.criterion_name = p_crt_name
          AND wccv.criterion_type = wms_xdock_utils_pvt.G_CRT_TYPE_PLAN;

Line: 252

       SELECT mtrh.header_id
            , mtrh.move_order_type
         FROM mtl_txn_request_lines    mtrl
            , mtl_txn_request_headers  mtrh
        WHERE mtrl.line_id   = p_line_id
          AND mtrh.header_id = mtrl.header_id;