APPS.WIP_WS_CUSTOM SQL Statements

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

Line: 171

  select abs(nvl(sum(mmt.transaction_quantity),0))
  into l_issue_qty
  from mtl_material_transactions mmt
  where mmt.transaction_source_type_id = 5
  and mmt.transaction_source_id = p_job_id
  and mmt.organization_id= p_org_id
  and mmt.inventory_item_id = p_comp_item_id
  and mmt.operation_seq_num = p_op_seq
  and mmt.transaction_action_id in (1,27,33,34)
  and mmt.attributeXX = p_assy_serial;