APPS.GMI_PICK_CONFIRM_PUB SQL Statements

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

Line: 109

  SELECT *
    FROM ic_txn_request_lines
   WHERE line_id = p_mo_line_id;

Line: 114

  SELECT ic.*
    FROM wsh_delivery_details wsh,
         ic_txn_request_lines ic
   WHERE ic.line_id = wsh.move_order_line_id
     AND wsh.delivery_detail_id = p_delivery_detail_id;

Line: 122

  SELECT *
    FROM ic_whse_mst
   WHERE mtl_organization_id= p_organization_id;

Line: 128

  SELECT count(*)
    FROM ic_tran_pnd
   WHERE delete_mark   = 0
     AND completed_ind = 0
     AND staged_ind    = 0
     AND (lot_id <> 0 OR location <> l_default_loct)
     AND doc_type      = 'OMSO'
     AND line_id       = p_line_id
     AND line_detail_id in (
         SELECT delivery_detail_id
           FROM wsh_delivery_details
          WHERE move_order_line_id = p_mo_line_id);

Line: 142

  SELECT count(*)
    FROM ic_tran_pnd
   WHERE delete_mark   = 0
     AND completed_ind = 0
     AND staged_ind    = 0
     AND doc_type      = 'OMSO'
     AND line_id       = p_line_id;

Line: 515

SELECT NVL( SUBSTR( value, 1, instr( value, ',')-1), value)
FROM v$parameter
WHERE name = 'utl_file_dir';